In that application no wildcards are needed.

You would use wildcards if:

Search for Q?3

Where ? is any single character

Search for Q*3

Where * is any number of characters or no characters followed by a 3.

A2 = Q1123

=COUNT(SEARCH("Q?3",A2)) = 0
=COUNT(SEARCH("Q*3",A2)) = 1

A2 = Q13

=COUNT(SEARCH("Q?3",A2)) = 1
=COUNT(SEARCH("Q*3",A2)) = 1

--
Biff
Microsoft Excel MVP


"Fred Smith" wrote in message
...
Search accepts wildcards, so if you want to search for contains "Q3", use
"*Q3*". Ditto for the others in the list.

Regards,
Fred

"Jen_T" wrote in message
...
Is it possible for a formula to look in cell and check if it contains
specific text? I was provided the following formula, below, but it only
checks to see if cell value contains only those values but not if it
includes
it.

For example: cell value - Test0408AU ="Exist"

=IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU","0408 SL","0408","0109","0209","0309","0409"},A1)),"Exis t","Cannot
find")