Flag any product title over the 60-character limit
The shop platform rejects product titles longer than 60 characters and the bulk uploader doesn't tell you which row blew the limit. Add a length column so the merchandiser can fix the offenders before the import runs.
Count characters in product titles
Practice using LEN to solve a real small business problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
Your e-commerce platform limits product titles to 60 characters. Before bulk-uploading, you want a column showing each title's length so you can spot violations.
In B2, return the number of characters in the product title in A2. Spaces and punctuation count too.
LEN returns the number of characters in a text string, counting every space, punctuation mark, and invisible character. The simplest text function in Excel and the bedrock for length validation, truncation logic, and data-quality checks.
LEN(text)Try the formula first. Hints cost CP for a reason.