FIND

See also A-Z Spreadsheet Function List

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])

search_text is the text to find. If you specify an empty string (""), FIND matches the first character in text.

text is the text to be searched.

start_position is the character position in text where the search begins. The first character in text is character number 1. When 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.

See Also EXACT , LEN , MID , and SEARCH functions

Examples FIND(“time”, “There’s no time like the present”) returns 12

         FIND(“4”, “Aisle 4, Part 123-4-11”, 9) returns 19