How can I insert same word into selected column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert the same word at the start of a column of cells 3
VBA - retrieve data on last create named range from previous inserted named range 0
Inserting Rows into multiple worksheets 2
MacroLimitInWordDocument 1
trying to insert a 0 in front of zipcode 2
Insert Column with macro 2
Making a sound on condition of textbox 4
Can I insert references (citations from RefMan) into Excel? 1

Back
Top