Maximum number of characters in a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-66355%22%20slang%3D%22en-US%22%3EMaximum%20number%20of%20characters%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-66355%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20How%20can%20i%20get%20a%20maximun%20of%20characters%20in%20a%20cell%3F%20Is%20that%20possible%20in%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-66355%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-67702%22%20slang%3D%22en-US%22%3ERe%3A%20Maximum%20number%20of%20characters%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-67702%22%20slang%3D%22en-US%22%3E%3CP%3EAll%20limits%20are%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FExcel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%23ID0EBABAAA%3DExcel_2016-2013%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FExcel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%23ID0EBABAAA%3DExcel_2016-2013%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-67659%22%20slang%3D%22en-US%22%3ERe%3A%20Maximum%20number%20of%20characters%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-67659%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20are%20asking%20how%20many%26nbsp%3Bcharacters%20can%20you%20enter%20in%20a%20cell%2C%20the%20answer%20is%20a%20lot%20more%20than%20just%20255%2C%20depending%20on%20your%20version%20of%20Excel.%20Allan%20Wyatt%20says%2032%2C767%20with%20some%20caveats%20%26nbsp%3B(%3CA%20href%3D%22https%3A%2F%2Fexcel.tips.net%2FT003163_Character_Limits_for_Cells.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ein%20this%20article%3C%2FA%3E).%20I%20frequently%20display%20more%20than%20255%20characters%20in%20a%20cell%2C%20though%20to%20do%20so%20usually%20means%20using%20Word%20Wrap%20and%20smaller%20font.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20asking%20how%20to%20determine%20the%20maximum%20number%20of%20characters%20in%20a%20cell%20from%20a%20range%20of%20cells%2C%20such%20as%3C%2FP%3E%3CP%3EA1%20%3D%26nbsp%3Babcd%3C%2FP%3E%3CP%3EA2%20%3D%20abc%3C%2FP%3E%3CP%3EA3%20%3D%20abcdedf%3C%2FP%3E%3CP%3EA4%20%3D%26nbsp%3Babcdedfghij%3C%2FP%3E%3CP%3Ethen%20you%20can%20use%20an%20array%20formula%20such%20as%20%7B%3DMAX(LEN(A1%3AA4))%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20asking%20how%20to%20restrict%20a%20cell%20to%20a%20maximum%20number%20of%20characters%2C%20then%20the%20answer%20is%20to%20use%20Data%20%26gt%3B%20Data%20Validation%20and%20choose%20%22Text%20Length%22%20from%20the%20Allow%20field.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-67002%22%20slang%3D%22en-US%22%3ERe%3A%20Maximum%20number%20of%20characters%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-67002%22%20slang%3D%22en-US%22%3EAlso%2C%20if%20the%20character%20(%20'%20)%20is%20used%20as%20the%20first%20character%20in%20the%20cell%2C%20it%20will%20not%20be%20counted%20in%20length.%3CBR%20%2F%3EExample%2C%20the%20length%20of%20'123%20will%20be%20counted%20as%203.%3CBR%20%2F%3E%3CBR%20%2F%3EVijaykumar%20Shetye%2C%3CBR%20%2F%3ESpreadsheet%20Excellence%2C%3CBR%20%2F%3EPanaji%2C%20Goa%2C%20India%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-66933%22%20slang%3D%22en-US%22%3ERE%3A%20Maximum%20number%20of%20characters%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-66933%22%20slang%3D%22en-US%22%3EYou%20can%20type%20upto%20255%20characters%20in%20a%20cell%20(including%20spaces).%20To%20find%20length%20(characters%20entered)%20of%20that%20cell%2C%20you%20can%20use%20function%20'LEN()'.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-66369%22%20slang%3D%22en-US%22%3ERe%3A%20Maximum%20number%20of%20characters%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-66369%22%20slang%3D%22en-US%22%3E%3CP%3EWith%20only%20one%20exception%20if%20no%20special%20format%20is%20applied%20to%20the%20cell.%20For%20exmple%2C%20if%20in%20the%20cell%20is%20the%20number%203.14%20LEN()%20on%20it%20returns%204.%20If%20you%20format%20it%20as%203.1400%20the%20LEN%20also%20will%20be%204.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESame%20with%20text.%20If%20in%20the%20cell%20is%20the%20text%20%22abcd%22%20the%20LEN%20is%204.%20If%20you%20apply%20to%20this%20cell%20format%20like%20%22Here%20is%22%40%20the%20LEN%20also%20returns%204.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-66364%22%20slang%3D%22en-US%22%3ERe%3A%20Maximum%20number%20of%20characters%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-66364%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Harsha%2C%20you%20can%20use%20LEN()%20funciton%20for%20this%20purpose.%20Please%20note%20that%20it%20will%20include%20spaces%20into%20the%20count.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1591396%22%20slang%3D%22en-US%22%3ERe%3A%20Maximum%20number%20of%20characters%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591396%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53563%22%20target%3D%22_blank%22%3E%40Harsha%20Debipersad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMicrosoft%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EExcel%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bhas%20a%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Echaracter%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Blimit%20of%2032%2C767%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Echaracters%26nbsp%3B%3C%2FSTRONG%3Ein%20each%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi, How can i get a maximun of characters in a cell? Is that possible in Excel?

 

Thanks

7 Replies
Highlighted

Hi Harsha, you can use LEN() funciton for this purpose. Please note that it will include spaces into the count.

Highlighted

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.

Highlighted
You can type upto 255 characters in a cell (including spaces). To find length (characters entered) of that cell, you can use function 'LEN()'.
Highlighted
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
Highlighted

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.

Highlighted

@Harsha Debipersad 

Microsoft Excel has a character limit of 32,767 characters in each cell.