Formulas and Functions

Table Of Contents

Chapter 11 Text Functions 321

Examples

=SEARCH(”ra”, “abracadabra”) returns 3; the rst occurrence of the string “ra” starts at the third

character in “abracadabra”.

=SEARCH(”ra”, “abracadabra”, 5) returns 10, the position of the rst occurrence of string “ra” when you

start looking at position 5.

=SEARCH(“*card”, “Wildcard”) returns 1, since the asterisk at the beginning of the search string

matches all the characters before “card”.

=SEARCH(“*cad”, “Wildcard”) returns an error, since the string “cad” does not exist.

=SEARCH(“?card”, “Wildcard”) returns 4, since the question mark matches the one character

immediately preceding “card”.

=SEARCH(“c*d”, “Wildcard”) returns 5, since the asterisk matches all the characters between the “c” and

“ d ”.

=SEARCH(“~?”, “Wildcard? No.”) returns 9, since the tilde means to interpret the next character (the

question mark) literally, not as a wildcard, and the question mark is the 9th character.