FIND
Use the FIND function to locate one text value within a second text value, and return the number of the starting position of the first text value from the first character of the second text value.
Use
FIND( find_text, within_text, [start_num] )
Finds the position of one text value within another (case-sensitive).
| Parameter | Required | Description |
|---|---|---|
| find_text | Yes | the text to find |
| within_text | Yes | the text to search for find_text |
| [start_num] | No | specifies the character at which to start the search (starting from 1) |
| Returns | Number |
Example
This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.
ON THIS PAGE