D
Dick W.
*east does not find Northeast in the following formula:-
=if(a1="*east",a1,"")
What am I doing wrong?
Office XP
Thanks, Dick W
=if(a1="*east",a1,"")
What am I doing wrong?
Office XP
Thanks, Dick W
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Try
=IF(COUNTIF(A1,"*east*"),A1,"")
--
Regards,
Peo Sjoblom
=IF(COUNTIF(A1,"*east*"),A1,"")
--
Regards,
Peo Sjoblom
M
Mike H
Maybe
=IF(SEARCH("east",A1,1),A1,"")
Mike
=IF(SEARCH("east",A1,1),A1,"")
Mike
P
Peo Sjoblom
That will throw an error if it doesn't find anything, you have to wrap it in
either ISNUMBER or ISERR/ISERROR
=IF(ISNUMBER(SEARCH("east",A1,1)),A1,"")
--
Regards,
Peo Sjoblom
either ISNUMBER or ISERR/ISERROR
=IF(ISNUMBER(SEARCH("east",A1,1)),A1,"")
--
Regards,
Peo Sjoblom
D
Dick W.
Thanks Peo and Mike your help is much appreciated.
Dick W.
Dick W.