Thread: How do a search for a text string using a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How do a search for a text string using a formula
=if(countif(a1,"*text*)0,"a","b")

is one way.



BobbyG wrote:

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?

--

Dave Peterson
Reply With QuoteReply With Quote