Excel Cell Character Limit and Other Text Limits Explained

The Excel cell character limit is 32,767 characters: that's the most text one cell can hold. Most people never reach it, but other text limits in Excel are much smaller and cause real problems: 255 characters for text inside a formula, 31 for a sheet name, 15 digits for a number. This guide lists the limits that matter, explains what happens when you hit them, and shows how to find and trim text that is too long. It's for anyone importing long descriptions, building upload files or puzzling over a strange error.

What is the Excel cell character limit?#

A single cell can store up to 32,767 characters, including spaces, punctuation and line breaks. That's roughly the length of a long report chapter.

Two details matter in practice:

• The cell may not show it all. Long text spills over empty neighbouring cells or gets cut off at the column edge. Click the cell and the formula bar shows the full text. Turn on Wrap Text (Home tab) to see more lines inside the cell.
• Formulas can't build longer text. If a formula such as CONCAT or TEXTJOIN would return more than 32,767 characters, it shows #VALUE! instead.

The limit is the same in Excel for Windows, Mac and Microsoft 365.

Other text and size limits in Excel#

These limits catch people out far more often than the 32,767 cap:

The 15-digit limit is why long ID numbers and card numbers lose their last digits. Store them as text instead; the guide to fixing scientific notation in Excel shows how. If you see "You've entered too many arguments for this function", see how to fix the too many arguments error.

How to count characters with LEN#

LEN returns the number of characters in a cell. Spaces count, and so do line breaks:

=LEN(A2)

If A2 holds "Regional summary for all North and South branches", LEN returns 49. To check text against a limit, compare the result:

=IF(LEN(A2)>31,"Too long","OK")

To count all the characters in a range, use =SUMPRODUCT(LEN(A2:A100)). The LEN function guide has more examples, and the guide to counting characters and words shows how to count words too.

How to find cells that are over a limit#

COUNTIF can count long text with wildcards. In criteria, ? matches exactly one character and * matches any number of characters. So 32 question marks followed by * matches any text of 32 characters or more. Instead of typing 32 question marks, build the pattern with REPT:

=COUNTIF(A2:A6,REPT("?",32)&"*")

With these proposed sheet names, the result is 2:

Wildcards only match text, so numbers are never counted this way. To highlight the long cells instead, use conditional formatting with the formula =LEN($A2)>31.

How to cut text down to a limit with LEFT#

LEFT keeps the first characters of a cell and drops the rest:

=LEFT(A3,31)

This returns the first 31 characters: "Regional summary for all North " (note the trailing space). Wrap it in TRIM to remove it. To show that text was cut, add an ellipsis only when needed:

=IF(LEN(A3)>31,LEFT(A3,28)&"...",A3)

That keeps the result at exactly 31 characters. To cut at the last whole word instead of mid-word, see how to truncate text in Excel. The LEFT function guide covers the syntax.

Common problems caused by text limits#

• Cell shows #### instead of text. A cell formatted as Text that holds more than 255 characters can display ####. Change the format to General; the text is still there.
• COUNTIF gives the wrong count on long text. Criteria longer than 255 characters don't match properly. Compare with = instead, which has no such limit: =SUMPRODUCT(--(A2:A100=E1)) counts the cells that equal the long text in E1. The guide to COUNTIF not working covers other causes.
• A long formula string is rejected. Split text over 255 characters into parts joined with &, or keep it in a cell and refer to the cell.
• Imported text looks cut off. Check the source file. Excel itself keeps up to 32,767 characters, but other systems often export shorter fields.
• Uploads fail on another system. Many systems have their own field limits, such as 40 or 255 characters. Check the lengths with LEN before you upload.

Practise it#

Working with text limits comes down to counting characters, cutting text and matching patterns. Practise LEFT, RIGHT, MID and LEN in a live spreadsheet, then practise wildcards and cell-based criteria to count cells by pattern. Each lesson checks your formula instantly. Then try the exercise on this page to count the sheet names that are too long.