Wildcards in If Statement

[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.

 

[Peo Sjoblom]

One way

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

--

Regards,

Peo Sjoblom

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.

 

[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).