Returns the position at which the specified text is found in another specified text, starting at the specified position.
Syntax
 Copy Code
|
|---|
SEARCH( 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, start 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: "=SEARCH(A1,B1,SEARCH(A1,B1)+1)".
Example
| Formula
Copy Code
|
|---|
=SEARCH("brown",A1) |
See Also
Function Reference
FIND Function
EXACT Function
MID Function
REPLACE Function
SUBSTITUTE Function