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