How to Count Characters in Excel with LEN

Open your Excel label list (.xlsx) in Cue Office and use LEN to count characters, including spaces and punctuation. Then use IF to flag labels over 20 characters or left blank.

Does LEN count spaces and punctuation?

Create a new spreadsheet in Cue Office and paste the practice data into cell A1. Column B contains the label text, column C holds the character count, and column D shows the review status.

Label table with three text entries and one blank cell in column B, with columns C and D awaiting data
Four labels to review, with the text cell for L04 left blank.

Select C2 and paste the four-row, two-column formulas below to fill C2:D5. On each row, LEN on the left counts the characters from column B, while IF on the right returns a status based on the character count in that row.

=LEN(B2)	=IF(C2=0,"Missing",IF(C2>20,"Too long","Fits"))
=LEN(B3)	=IF(C3=0,"Missing",IF(C3>20,"Too long","Fits"))
=LEN(B4)	=IF(C4=0,"Missing",IF(C4>20,"Too long","Fits"))
=LEN(B5)	=IF(C5=0,"Missing",IF(C5>20,"Too long","Fits"))

Count the two spaces, the hyphen, and the exclamation mark in Workshop check-in 1! in B3. The label has exactly 20 characters, so its status is Fits. Welcome desk in L01 has 12 characters and fits too.

Save and reopen the workbook to verify the character counts and statuses for all four records.

Results for the four labels after saving and reopening: 12 Fits, 20 Fits, 27 Too long, and 0 Missing
The reopened manual workbook shows results preserved for each of the four labels.

How can I flag text that is too long or missing?

The status formula checks for a count of 0 first. L04 is blank, so its count is 0 and its status is Missing. For each label with text, the formula checks whether the count exceeds 20. L03 has 27 characters and shows Too long. A label with exactly 20 characters still shows Fits.

In a copy of the workbook, change B4 from Please check in at the desk to Check in here. C4 updates from 27 to 13, and D4 changes from Too long to Fits. You can use these two columns together to test edits whenever you shorten labels.

L03 displays 13 and Fits after being shortened to Check in here
Compare the recalculated L03 results with the original results shown in the previous image.

How can Cue AI check all four labels?

In a copy that keeps the four original labels and leaves C2:D5 blank, open Cue AI from Home and send the prompt below.

Cue AI panel open alongside four labels and empty cells in C2:D5, with Character count and Status headers visible
Before sending the prompt, make sure both column headers are present and C2:D5 is blank.
Could you check the label text in B2:B5? In column C, count the characters, including spaces and punctuation. In column D, mark blank text as Missing, text over 20 characters as Too long, and everything else as Fits. Make both columns update when I edit the label text. Only fill C2:D5, and keep the existing headers, label text, and all other cells unchanged.

In this example, Cue AI added formulas only in C2:D5. Save and reopen the copy. Check that the Character count and Status headers are still there, then verify the counts and statuses for all four labels.

After reopening the AI copy, the original label text and headers remain intact, showing results of 12 Fits, 20 Fits, 27 Too long, and 0 Missing
Check a short label, a label exactly at the limit, a long label and a blank label.

Change B4 to Check in here. C4 updates to 13 and D4 updates to Fits.

Practice with the Event Label Table

Show the full example

Create a new spreadsheet in Cue Office, select A1, and paste the data below. The text for L04 is left blank to test Missing. Then return to the formula steps to enter formulas starting in C2.

Label ID	Label text	Character count	Status
L01	Welcome desk
L02	Workshop check-in 1!
L03	Please check in at the desk
L04

Check print proofs against the label IDs

If the character limit changes for the next batch, give Cue AI the new limit, the text column and the cells to fill. Spot-check one label that hits the limit exactly and one with missing text. Once the text is revised, check that every label previously marked Too long now fits.

When the printer sends PDF proofs (.pdf), open them for free in Cue Office and match each label’s text to its ID in the Excel list (.xlsx). If a proof still uses an earlier version, put the label ID and final text in a Word correction sheet (.docx). If a PowerPoint event deck (.pptx) uses the same label heading, update it there too. Cue Office offers free spreadsheet, document and presentation editing.

Download Cue Office for free