LEN, LEFT, RIGHT, MID - Free Excel Practice Online

This free, interactive exercise teaches you LEN, LEFT, RIGHT, MID 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, RIGHT, MID 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, RIGHT, MID lesson

1. The LEFT function returns a specified number of characters from the left end of a string of text. In the formula bar type in=LEFT(C4, 5)What is the resulting text?
2. The RIGHT function returns a specified number of characters from the right end of a string of text. In cell G2 try=RIGHT(C4, 3)What is the resulting text?
3. The LEN function returns the length of text in number of characters. Try the following formula: =LEN(A2)How many characters are in the word "Albany"?
4. The MID function returns text of a specified length from the middle of a larger string of text, starting at a specified position. The following formula starts on the second character of the text in C2 and returns 6 characters: =MID(C2, 2, 6) What is the resulting text?
5. What does =MID(A2, 2, 4) return?
6. What does =MID(E3, 1, 4) return?
7. What does =MID(C4, 4, 7) return?
8. What does =MID(B4, 4, 7) return?
9. What does =MID(D3, 2, 1) return?
10. What does =MID(B12, 3, 6) return?

LEN, LEFT, RIGHT, MID practice - FAQ