SEARCH

Returns the position at which the specified text is found in another specified text, starting at the specified position.

Syntax

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

=SEARCH("brown",A1)

See Also

Function Reference
FIND Function
EXACT Function
MID Function
REPLACE Function
SUBSTITUTE Function