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" <xtrmhyper.1rblub_1119935105.442@excelforum-nospam.com> wrote in
message news:xtrmhyper.1rblub_1119935105.442@excelforum-nospam.com...
>
> 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?
>
>
> --
> xtrmhyper
> ------------------------------------------------------------------------
> xtrmhyper's Profile:
> http://www.excelforum.com/member.php...o&userid=23851
> View this thread: http://www.excelforum.com/showthread...hreadid=382700
>

[xtrmhyper]

tnx bro
all formula is working

god speed