contains formula


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?action=getinfo&userid=23851
View this thread: http://www.excelforum.com/showthread.php?threadid=382700

.

Loading