Help w/ adding information to an existing column

**MC Advantages** · 05-18-2009, 02:06 PM

I have a column of numbers and need to add two letters ('SS') in front of all of the numbers, is there an easy way to do this?

**Miraun** · 05-18-2009, 02:32 PM

Heya. I have a very fast workaround for you. Insert a column before, and after the column with all of the numbers.

In the column to the left, put in the "SS" string that you wanted. Fill it down to the end of your number string

In the column on the right, use =CONCATENATE(A1,B1) (assuming your SS is in A1, and the ##s in B1)

Fill the results of the third column down to the end... that will be the SS### data you wanted...

Of course though, I'm sure you don't want ALL of this in there, so copy the row with the concatenated data, and copy. Then highlight the column with just the number data, and paste special. Select Values and hit OK, and you've just added SS to all of the numbers in that column.

There may be another way, but this will work just fine!

**DonkeyOte** · 05-18-2009, 02:34 PM

Do you need to physically append the values or merely alter their appearance, ie applying a custom format of:

"SS"0

to the range of numbers would alter the display but leave underlying values unchanged

If you need to change the values themselves, in formula terms you would need to use an adjacent column and copy paste values the results, ie

="SS"&A1
copied down

Else you're looking at a VBA solution, using Evaluate or a Loop.