adding a word of text to a column

J

Just a sales guy

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?
 
B

Bernie Deitrick

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
 
Top