Alpha conditional statements
Thanks Peo and Mike your help is much appreciated.
Dick W.
"Peo Sjoblom" wrote:
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
"Mike H" wrote in message
...
Maybe
=IF(SEARCH("east",A1,1),A1,"")
Mike
"Dick W." wrote:
*east does not find Northeast in the following formula:-
=if(a1="*east",a1,"")
What am I doing wrong?
Office XP
Thanks, Dick W
|