contains formula

[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?

 

[Biff]

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

 

[xtrmhyper]

tnx bro
all formula is working

god spee