FIND

Searches for the specified string in another string and returns the found position or an error.

Syntax

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

=FIND("brown",A1)

See Also

Function Reference
EXACT Function
LEN Function
MID Function
SEARCH Function