Wildcards in If Statement

S

Stevkev

It's driving me bonkers. I need to retrieve a true value if the text in a cell contains the word "Rows" plus an * wildcard in an If statement. I am at a loss on what syntax to use to retrieve this value.
 
P

Peo Sjoblom

One way

=IF(ISNUMBER(SEARCH("Rows",A1)),"contains","contains not")

--

Regards,

Peo Sjoblom

Stevkev said:
It's driving me bonkers. I need to retrieve a true value if the text in a
Click to expand...
cell contains the word "Rows" plus an * wildcard in an If statement. I am
at a loss on what syntax to use to retrieve this value.
 
D

Dave Peterson

if that rows is followed directly by an asterisk, then a minor change to Peo's
formula:

=IF(ISNUMBER(SEARCH("Rows~*",A1)),"contains","contains not")

or a different formula:
=IF(COUNTIF(A1,"*rows~**")>0,"contains","contains not")

the ~* means to look for the asterisk itself--not any set of characters
(represented by the wild card).
 
Top