Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 4/6

FIND and SEARCH

Exercise 1 of 4

In B2, find the position of the space in Ana's name.

About this lesson

FIND and SEARCH return the position of one text inside another. Learn how they differ on upper and lower case and wildcards.

In this lesson

  1. In B2, find the position of the space in Ana's name.
  2. In B2, find the position of the @ in the email.
  3. In B2, find where "silva" (in lower case) starts in Ana's name.
  4. What's the difference between FIND and SEARCH?

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in B2 and press Enter to check.