SEARCH
Return the index of the search text within the text. The search starts at index.
Syntax
=SEARCH(TextToSearch, Text, [StartAt])
Arguments
| Name | Description |
|---|---|
| TextToSearch | Text to search for. Note: wildcards like * or ? are supported. |
| Text | Text to search inside. |
| StartAt (optional) | Character index to start search at. Default is 1. |
Return
Position, where the text is found, otherwise #VALUE.
Examples
| Formula | Result | Comment |
|---|---|---|
| 8 | |
| 1 |