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

Argument 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] Optional. The character position in text where the search begins. The first character in text is character number 1. If this argument is omitted, 1 is used.

Argument	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]	Optional. The character position in text where the search begins. The first character in text is character number 1. If this argument is omitted, 1 is used.

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

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)

See Also EXACT, LEN, MID, SEARCH