contains formula

  • Thread starter Thread starter xtrmhyper
  • Start date Start date
X

xtrmhyper

in column a
i have this data

A B
1 hyper sdfju sdf
2 df hyper sdf
3 sf hyper df
4 sdf sdf hyper

if column A row 1, 2 , 3 , 4 contains word hyper
in column B r0w 1, 2, 3, 4 will have automatically the word hyper
what is the formula?
 
Hi!

In B1 enter one of these formulas and copy down as needed:

=IF(COUNTIF(A1:A4,"*hyper*"),"hyper","")

=IF(ISNUMBER(SEARCH("hyper",A1)),"hyper","")

=IF(ISNUMBER(SEARCH(" hyper "," "&A1&" ")),"hyper","")

The last formula is slightly more robust than the others in that it is only
looking for the specific word. It won't "see" 'hyperactive" but the other
formulas will. It also won't "see" "hyper!".

Biff
 
Back
Top