adding a word of text to a column

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

Guest

In Excel, I need to add the word "each" to an existing column of text. Is
there a way to paste this word in without having to add it into each row, one
row at a time?
 
Sales Guy,

Insert a new column, then use a formula like

=A1 & " each"

or, if you have numbers that require formatting

=TEXT(A1,"$0.00") & " each"

Then copy the formula down to match your column of text, copy all of those
formulas, paste special / values to convert them to strings, then delete
your original column of data.

HTH,
Bernie
MS Excel MVP
 
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

Text to columns 2
Split column contents (de-concantenate) 7
organizing rows and columns by text 1
Copy & Paste 2
Specific words Categorizaion 1
Plain text to fill a single column: how? 2
Excel Help to copy information from one row at a time to another sheet 1
Maximum Text in Cells for Printing 1

Back
Top