Practice by topic / Excel / Text Functions
Imported data is messy: extra spaces, inconsistent capitals, codes glued together. Text functions clean and reshape it without retyping anything. These 10 exercises build up step by step, starting with check a username's length, validate a password length requirement, count characters in a product code.
3 of 10 free · no sign-up needed · graded on the formula you write
A1 holds a username. Write a formula in A2 that returns how many characters it has using LEN.
| A | |
|---|---|
| 1 | coder123 |
| 2 | ? |
Use =LEN(A1).
Right — LEN counts every character in the string, including numbers and symbols.
Expected result in A2: 8
A1 holds a password. Write a formula in A2 that returns TRUE if it has at least 8 characters, using LEN.
| A | |
|---|---|
| 1 | hunter22 |
| 2 | ? |
Use =LEN(A1)>=8.
Good — wrapping LEN in a comparison is the standard way to validate minimum length.
Expected result in A2: true
A1 holds a product code. Write a formula in A2 that returns its character length using LEN.
| A | |
|---|---|
| 1 | SKU-88213 |
| 2 | ? |
Use =LEN(A1).
Right — LEN works the same on codes with letters, numbers, and dashes.
Expected result in A2: 9
A1 holds a comment string. Write a formula in A2 that returns TRUE if it's over 100 characters, using LEN.
| A | |
|---|---|
| 1 | This is a short comment. |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a phone number as text. Write a formula in A2 that returns its length using LEN, to check for the expected 10 digits.
| A | |
|---|---|
| 1 | 5125550199 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 might be blank. Write a formula in A2 that returns TRUE if A1 has zero-length content, using LEN.
| A | |
|---|---|
| 1 | |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds an article title. Write a formula in A2 that returns its length using LEN.
| A | |
|---|---|
| 1 | How to Learn Excel Fast |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a code that should be exactly 6 characters. Write a formula in A2 that returns TRUE if it is exactly 6 characters, using LEN.
| A | |
|---|---|
| 1 | AB1234 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a message, and the limit is 280 characters. Write a formula in A2 that returns how many characters remain using LEN.
| A | |
|---|---|
| 1 | Just shipped a new feature! |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a hashtag-style tag. Write a formula in A2 that returns its length using LEN.
| A | |
|---|---|
| 1 | #excelpractice |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →