contains formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

xtrmhyper - 28 Jun 2005 05:25 GMT

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?

Signature

xtrmhyper

Reply to this Message

Biff - 28 Jun 2005 06:58 GMT

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

> in column a
> i have this data
[quoted text clipped - 8 lines]
> in column B r0w 1, 2, 3, 4 will have automatically the word hyper
> what is the formula?

Reply to this Message

xtrmhyper - 28 Jun 2005 08:05 GMT

:) tnx bro

all formula is working

god spee

Reply to this Message