Arguments can be provided as numbers names arrays or references that contain numbers. Excluding apostrophe symbol if occurred as a first character in the cell. The Excel LEN function returns the length of a given text string as the number of characters.
Open the file in excel parse it if its text Insert a new row above the header row.
Enter the following formula in every column of the new row that is being imported MAXLENA2A65636. Arguments can be provided as constants or as cell references or ranges. The MAX function in current versions of Excel accepts up to 255 arguments. In MS Excel 2007 and later versions we can provide up to 255 number arguments to the MAX function.