Text Functions
Beginner
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.
Learning Objectives:
- Learn LEN function
- Understand character counting
- Practice text length validation
Hints
Solve without hints for +5 XP
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.
| A | B | C | |
|---|---|---|---|
| 1 | Product Name | Length | Long Name (Yes/No) |
| 2 | Laptop | ||
| 3 | Smartphone | ||
| 4 | TV | ||
| 5 | Refrigerator | ||
| 6 | Microwave |
What this exercise teaches (contains the answer)
The LEN function counts all characters in a text string, including spaces. It's useful for data validation and text analysis.