Searches for the specified string in another string and returns the found position or an error.
Syntax
 Copy Code
|
|---|
FIND( Text search, Text text, [Integer start = 1] ) → Integer |
Parameters
- search
- Required. The text to find.
- text
- Required. The text that contains the searched text.
- start
- Optional. The position inside text at which to start the search. If omitted, it is assumed to be 1.
Remarks
If search is an empty string, the function returns 1. If search does not appear within text, the function returns the #VALUE! error value. If start is less than or equal to zero, the function returns the #VALUE! error message.
The start parameter can be used to skip a specified number of characters. For example, to find the second appearance of the string contained in cell A1 within the string contained in B1, use the following formula: "=FIND(A1,B1,FIND(A1,B1)+1)".
Example
| Formula
Copy Code
|
|---|
=FIND("brown",A1) |
See Also
Function Reference
EXACT Function
LEN Function
MID Function
SEARCH Function