Inserting a single number into a column where each row is a set of different numbers

I have a situation where I have a spreadsheet of 500 rows. One column in the row has a set of numbers that varies from row to row. I need to insert one number (it is the same number) to join all of the numbers in that cell. How do I do this. The numbers are listed in this format: 460, 1222, 1190, 1233, etc There must be an easy way as opposed to cutting and pasting that one number 500 times. And, yes, I am new at excel!

This is the way I would do it:

If all of your data is in column A and the number you want to add to each cell in column A is lets say 10. Add 10 to B1 copy it all the way down to the last cell in column A with your data. In C1 use the following formula:


=A1&" "&B2

Use the fill handle in the lower right hand corner of C1 to copy the formula all the way down to you last row with data.


This probably an easier way but this should work.

Oops! Correction to the formula. Should be: =A1&" "&B1 or you could write it like this =A1&" "&10. The " " designates a space between the numbers. If no space is needed write it: =A1&10. Hopefully, this will work for you.