Thread: Alpha conditional statements
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Alpha conditional statements
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
Reply With QuoteReply With Quote