Thread: How do a search for a text string using a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BobbyG BobbyG is offline
external usenet poster
  
Posts: 1
Default How do a search for a text string using a formula
Is it possible to use a =IF(A1=%TEXT%,"A","B") or
=IF(CONTAINS(A1,TEXT)=TRUE,"A","B") type formula? Like you can do using
autofilter but in a formula?
Reply With QuoteReply With Quote