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?