May 02 2017
02:04 AM
- last edited on
Jul 25 2018
09:34 AM
by
TechCommunityAP
May 02 2017
02:04 AM
- last edited on
Jul 25 2018
09:34 AM
by
TechCommunityAP
Hi, How can i get a maximun of characters in a cell? Is that possible in Excel?
Thanks
May 02 2017 02:24 AM
Hi Harsha, you can use LEN() funciton for this purpose. Please note that it will include spaces into the count.
May 02 2017 02:46 AM
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.
May 03 2017 08:06 PM
May 04 2017 02:52 AM
May 05 2017 05:28 PM
If you are asking how many characters can you enter in a cell, the answer is a lot more than just 255, depending on your version of Excel. Allan Wyatt says 32,767 with some caveats (in this article). I frequently display more than 255 characters in a cell, though to do so usually means using Word Wrap and smaller font.
If you are asking how to determine the maximum number of characters in a cell from a range of cells, such as
A1 = abcd
A2 = abc
A3 = abcdedf
A4 = abcdedfghij
then you can use an array formula such as {=MAX(LEN(A1:A4))}
If you are asking how to restrict a cell to a maximum number of characters, then the answer is to use Data > Data Validation and choose "Text Length" from the Allow field.
May 06 2017 02:05 AM
Aug 16 2020 04:36 AM
Microsoft Excel has a character limit of 32,767 characters in each cell.