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.
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.
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.
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.
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.
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.