How can I insert same word into selected column

Z

ZigZig

We need to insert same word in front each verb in selected columns. I
appreciate if anyone help me.
 
I

Ian

Use a helper column. In row 1 of a free column type =CONCATENATE("Prefix
",A1)
This will give you Prefix verb in the new cell. Copy the cell down as far as
required. Select the new column, copy then paste special>values over the
original data.
I've assumed your data starts at A1, but adjust the reference to suit.
 
Top