We need to insert same word in front each verb in selected columns. I
appreciate if anyone help me.
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("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.
--
Ian
--
"ZigZig" <[email protected]> wrote in message
news:[email protected]...
> We need to insert same word in front each verb in selected columns. I
> appreciate if anyone help me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks