G Guest Apr 30, 2004 #1 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.
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 Apr 30, 2004 #2 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.
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 Apr 30, 2004 #3 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).
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).
