06-28-2005, 02:05 AM
|
|
|
|
Re: contains 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
"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
>
|