Forum Discussion
Harsha Debipersad
May 02, 2017Copper Contributor
Maximum number of characters in a cell
Hi, How can i get a maximun of characters in a cell? Is that possible in Excel? Thanks
SergeiBaklan
May 02, 2017Diamond Contributor
With only one exception if no special format is applied to the cell. For exmple, if in the cell is the number 3.14 LEN() on it returns 4. If you format it as 3.1400 the LEN also will be 4.
Same with text. If in the cell is the text "abcd" the LEN is 4. If you apply to this cell format like "Here is"@ the LEN also returns 4.
vijaykumar shetye
May 04, 2017Brass Contributor
Also, if the character ( ' ) is used as the first character in the cell, it will not be counted in length.
Example, the length of '123 will be counted as 3.
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India
Example, the length of '123 will be counted as 3.
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India