FIND

Description

Searches for a string of text within another text string and returns the character position at which the search string first occurs.

Syntax

FIND ( search_text, "text" [, start_position] )

Parameter	Description
search_text	The text to find. If you specify an empty string (" "), FIND matches the first character in text.
text	The text to be searched.
start_position	The character position in text to begin the search. The first character in text is character number 1. If you omit this argument, the default starting position is character number 1.

Remarks

FIND is case-sensitive. You cannot use wildcard characters in the search_text.

If FIND does not find the search_text value, the function returns #ERROR!.

Examples

This function returns 12:

FIND("time", "There's no time like the present")

This function returns 19:

FIND("4", "Aisle 4, Part 123-4-11", 9)