LEN, LEFT, and RIGHT Functions - Free Excel Practice Online

This free, interactive exercise teaches you LEN, LEFT, and RIGHT Functions in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Text Search Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising LEN, LEFT, and RIGHT Functions this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this LEN, LEFT, and RIGHT Functions lesson

1. Use LEN( ) to get the number of characters in text. Type =LEN(A2) in the field below to get the length of the text in cell A2.
2. Use LEFT( ) to get the left-most characters of some text. Type =LEFT(A2, 4) to return the 4 left-most characters in the text, which is "Mike".
3. RIGHT( ) returns the right-most characters of some text. Try using =RIGHT( ) to return "Johnson"
4. What would LEN(A2) return? (Don't forget the space!)
5. Use a combination of LEFT and RIGHT to return "love"
6. Use LEN with the cell that will return 5.
7. Use RIGHT to return the word "words".
8. Use LEFT to return "E".
9. What would =LEN(B2) return?
10. Use a combination of LEFT and RIGHT to get "xce"

LEN, LEFT, and RIGHT Functions practice - FAQ