Forum Discussion
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
Hi Harsha, you can use LEN() funciton for this purpose. Please note that it will include spaces into the count.
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.
- 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
