search for text "beginning with" "containing" wildcards

  • Thread starter Thread starter David H
  • Start date Start date
D

David H

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 ?
 
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.
 
Back
Top