Microsoft Office Tutorials and References
In Depth Information
Comparing, Finding, and Measuring Text
Value in
Cell A1
Function
Result
Comment
Happy
birthday
to you
=SEARCH(“yo?”,A1)
19
The first place where
yo is followed by any
single character is the
word you.
Happy
birthday
to you
=SEARCH(“b*d”,A1)
7
The search pattern is
the letter b, followed
by any number of
characters, followed by the
letter d. This starts in
position 7.
Happy
birthday
to you
=SEARCH(“*b”,A1)
1
The asterisk says
search for any number
of characters before
the letter b. The start of
characters before the
letter b is at position
1. Using an asterisk at
the start is not useful.
It will either return a 1
or an error if the fixed
character(s) (the letter
b in this example) is not
in the larger text.
Happy
birthday
to you
=SEARCH(“t*”,A1)
10
The asterisk says
search for any number
of characters after
the letter t. Because
the search starts with
a fixed character, its
position is the result.
The asterisk serves no
purpose here.
Happy
birthday
to you
=SEARCH
(“t”,A,1,12)
16
Finds the position of
the first letter t, starting
after position 12. The
result is the position
of the first letter in the
word to. The letter t in
birthday is ignored.
 
Search JabSto ::




Custom Search