How do a search for a text string using a formula

  • Thread starter Thread starter BobbyG
  • Start date Start date
B

BobbyG

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?
 
=if(countif(a1,"*text*)>0,"a","b")

is one way.


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?
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

True/False for finding text in cells 2
Concantenate which keeps bold of some parts. 5
Delimit using a formula 2 4
Combining Text From Cells 3
Find a value in table 2
Finding Text within an Array 2
SEARCH but for cell contents rather than text 2
If formula and text search 14

Back
Top