Thread: Alpha conditional statements
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default Alpha conditional statements
Try

=IF(COUNTIF(A1,"*east*"),A1,"")


--


Regards,


Peo Sjoblom

"Dick W." wrote in message
...
*east does not find Northeast in the following formula:-
=if(a1="*east",a1,"")
What am I doing wrong?
Office XP
Thanks, Dick W


Reply With QuoteReply With Quote