Microsoft Office Tutorials and References
In Depth Information
FIND finds one text string (find_text) within another text string (within_text)
and returns the number of the starting position of find_textfrom the first
character of within_text. You can also use SEARCH to find one text string
within another, but unlike SEARCH, FIND is case-sensitive and doesn ’ t al-
low wildcard characters.
The FIND function takes the following arguments:
find_text — This is the text you want to find. If find_textis "" (that
is, empty text), FIND matches the first character in the search string
(that is, the character numbered start_numor 1). find_textcannot con-
tain any wildcard characters.
within_text — This is the text that contains the text you want to find.
start_num — This specifies the character at which to start the
search. The first character in within_textis character number 1. If
you omit start_num, it is assumed to be 1.
SEARCH returns the number of the character at which a specific character
or text string is first found, beginning with start_num. You use SEARCH to de-
termine the location of a character or text string within another text string
so that you can use the MID or REPLACE function to change the text.
The SEARCH function takes the following arguments:
find_text — This is the text you want to find. You can use the wild-
card characters question mark (?) and asterisk (*) in find_text. A
question mark matches any single character; an asterisk matches any
sequence of characters. If you want to find an actual question mark
or asterisk, you type a tilde (~) before the character. If you want to
find a tilde, you type two tildes. If find_textis not found, a #VALUE!
error is returned.