FIND
Finds text within a string value (case-sensitive).
Syntax
=FIND(Text, WithinText, [FromPos])
Arguments
| Name | Description |
|---|---|
| Text | A string value to look for. |
| WithinText | A string value to look in. |
| FromPos (optional) | A start position which specifies the first character to start the search at. Default is 1. |
Return
Returns the place where to find the searched character in the string.
Examples
| Formula | Result | Comment |
|---|---|---|
| 5 |