FIND Function - Free Excel Practice Online

This free, interactive exercise teaches you FIND Function 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 FIND Function 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 FIND Function lesson

1. The FIND function returns the first position of a string of text within a larger string of text. For example, "i" is at position 2 in "Mississippi" because the first "i" is the second character. What would =FIND("s", A1) return?
2. What would =FIND("iss", A1) return?
3. Write a FIND function that searches for the first "ssi" in "Mississippi."
4. What would =FIND(". ", A4) return?
5. FIND has an optional third parameter that tells the function where to start searching. =FIND("ssi", A1, 5) starts searching A1 at position 5, so it only searches "issippi". Because of this FIND will not find the position of the first "ssi" and will look for the next "ssi." What would =FIND("ssi", A1, 5) return?
6. What would =FIND("o", A2, 3) return?
7. What would =FIND("o", A2, 5) return?
8. FIND is case-sensitive. What would =FIND("r", A5) return?
9. What would =FIND("R", A5) return?
10. What would =FIND("R", A5, 10) return?

FIND Function practice - FAQ