ExcelBanter - How do a search for a text string using a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do a search for a text string using a formula (https://www.excelbanter.com/excel-discussion-misc-queries/180744-how-do-search-text-string-using-formula.html)

BobbyG

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?

Dave Peterson

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

All times are GMT +1. The time now is 10:47 PM.