Skip to content
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.