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