close
We need to insert same word in front each verb in selected columns. I
appreciate if anyone help me.
Use a helper column. In row 1 of a free column type =CONCATENATE(quot;Prefix
quot;,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 specialgt;values over the
original data.
I've assumed your data starts at A1, but adjust the reference to suit.
--
Ian
--
quot;ZigZigquot; gt; wrote in message
...
gt; We need to insert same word in front each verb in selected columns. I
gt; appreciate if anyone help me.
全站熱搜
留言列表
