FIND Function
Finds one text string contained within another text string, and returns the starting position of the text string you are seeking relative to its position in the text string that contains it.
Syntax
FIND (find_text, within_text,[ start_num ], [ ignore_case ])
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| find_text |
Required |
String |
The text string you want to find. |
| format |
Required |
String |
The text string that contains the text you want to find. |
| start_num |
Optional |
Number |
The character at which to start the search. The first character in within_text is 1. If start_num is missing, it is assumed to be 1. |
| ignore_case |
Optional |
Boolean |
By default, the FIND function is case-sensitive. If you want the FIND function to ignore case, set this argument to TRUE. |
Return value
Number
Remarks
If multiple matches are found, the FIND function returns the starting position of the first match in the string. The find_text argument does not consider any characters to be wildcards.
If find_text:
- Is empty (""), FIND matches the first character in the search string (that is, the character numbered start_num or 1).
- Does not appear in within_text, FIND returns the #VALUE! error value.
If start_num:
- Is not greater than zero (0), FIND returns the #VALUE! error value.
- Is greater than the length of within_text, FINDreturns the #VALUE! error value.
Example
FIND ("2003","January 1, 2003")
Returns 12.