search for text "beginning with" "containing" wildcards
 

I have numerous occasions where functions (like countif) need to report on
cells containing text strings or starts with text strings.

In various database utilities there are wildcards which provide this
functionality, but what about in Excel, do any wildcards work ?

search for text "beginning with" "containing" wildcards
 

In some functions, they do:

=countif(a1:a10,"text*")
=countif(a1:a10,"*text")
=countif(a1:a10,"*text*")

And you can use
"*" & x99 & "*"
as the second argument.

If you want to look for an asterisk character, use ~* in the string.
If you want to look for a question mark, use ~? in the string.
If you want to look for a tilde (~), use ~~ in the string.




David H wrote:

I have numerous occasions where functions (like countif) need to report on
cells containing text strings or starts with text strings.

In various database utilities there are wildcards which provide this
functionality, but what about in Excel, do any wildcards work ?

--

Dave Peterson