SEARCH
Use the SEARCH function to find the starting position of one text value within another text value, returning the position of the first character of the first text value in the second text value.
Use
SEARCH( find_text , within_text [, start_num] )
Finds the position of one text value within another (case-insensitive).
| Parameter | Required | Description |
|---|---|---|
| find_text | Yes | the text to find |
| within_text | Yes | the text to search |
| 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