FIND function in Excel

Syntax

=FIND(find_text, within_text, [start_num])

Example

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

From the lesson FIND Function.

Common mistakes

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

Related text functions

• LENReturns the number of characters.
• LEFTReturns characters from the start of the text.
• RIGHTReturns characters from the end of the text.
• MIDReturns characters from the middle of the text.
• SEARCHCase-insensitive position of text; supports wildcards.
• CONCATJoins text from cells and ranges.
• CONCATENATEJoins text items (legacy).
• TEXTJOINJoins text with a delimiter.