Thread: how to search in a column

hey all,

suppose i have column A with texts and numbers
john123
ab-john
123john

can i create in B formula to read only the word john if exists or not in A ?

thanks

You can use wildcards with both MATCH & COUNTIF functions, ie:

=ISNUMBER(MATCH("*john*",A1:A100,0))

or

=COUNTIF(A1:A100,"*john*")>0

Originally Posted by JeanRage

Hi,

You can try


HTH

Works

but i had to start from b2 copied down

thank you