Text FunctionsBeginner

LEN Function

Count the number of characters in a text string.

Task:

Calculate the length of each text string in column A and display it in column B. Also, determine in column C if each text is longer than 10 characters.

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.

    CoreBeginner
  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 columns10 cells you fill in
ABC
1Product NameLengthLong Name (Yes/No)
2Laptop
3Smartphone
4TV
5Refrigerator
6Microwave

Functions used here

What this exercise teachesMay contain the answer

The LEN function counts all characters in a text string, including spaces. It's useful for data validation and text analysis.