FIND Function

Freebeginner 15 min4 tasks0/66 pts

FIND tells you the position of one piece of text inside another, and it is case-sensitive. On its own it is just a number, but it is perfect for feeding LEFT and MID so they work on text of any length.

Syntax

FIND(find_text, within_text, [start_num])

Example: =FIND("@","ana@mail.com") returns 4. =LEFT(A2,FIND("@",A2)-1) returns everything before the @.

Common mistakes

FIND is case-sensitive; use SEARCH when case should not matter.
FIND returns #VALUE! if the text is not found.

LEN, LEFT, RIGHT, MID Practice SEARCH Function