I. Intro
The FIND function locates the position of a text string within another string.
II. About the function
- Formula: =FIND(search_for,text_to_search,[starting_at])
- Arguments:
- search_for (required): The text string you want to find (what to look for).
- text_to_search (required): The cell containing the text you want to find (where to look).
- starting_at (optional): The position of the character from which to start the search. For example, if the start position is 1, the search will start from the first character in the cell.
- Example:
- =FIND("ha",A2,1) results in 5.
- In this example, the search starts from the first character, and the result shows "ha" is found in the fifth position.
III. Steps
Use the FIND function
- Select a cell and click Formulas on the toolbar, then select Text > FIND. You can also directly enter =FIND in a cell.
- Enter the arguments in the cell. For example: =FIND("@",F2,1).
- Press Enter to get the result.
250px|700px|reset
Delete the FIND function
Select the cell with the FIND function and press Delete.