Text Functions
Beginner

LEN against a character limit

Will it fit? Check text against a limit before it gets cut off.

Task:

The marketplace truncates product titles after 30 characters. In C2:C6 show Too long for any title over 30 characters, and OK for the rest.

Interactive Spreadsheet

Read about LEN

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of LEN

0/3

The same formula in the other shapes it takes at work.

  1. LEN Function

    Count the number of characters in a text string.

    Core
    Beginner
  2. LEN against a character limit

    Will it fit? Check text against a limit before it gets cut off.

    Beginner
  3. Count how often a character appears

    LEN before minus LEN after removing it — the classic counting trick.

    Advanced

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

6 rows × 3 columns5 cells you fill in
ABC
1SKUTitleFits?
2K-01Stainless steel kettle 1.7L
3K-02Cordless glass kettle with blue LED
4K-03Travel kettle 0.5L
5K-04Gooseneck pour-over kettle, matt
6K-05Whistling stovetop kettle 2.5
What this exercise teachesMay contain the answer

Spaces and commas count towards a limit just like letters, which is exactly why eyeballing a title does not work. Exactly 30 characters still fits; the test is > 30, not >= 30.