Adding more #'s to Excel cells

August 9, 2006 at 17:38:53
Specs: xp home, 512
I have a spreedsheet with a colunm of phone numbers, I need to add the area code 604 to all of them...... is there a way to do this other than one at a time?

See More: Adding more #s to Excel cells

Report •

August 9, 2006 at 18:38:03

You can create a new column and use a function to concatenate data to the beginning of the contents in another column.

Column A has format of 555-1234
Add a new column and make the formula =CONCATENATE("604-",A1)

You can then "Fill Down" and all of your data in Column A should be appended with "604-"

Hope this helps!

Curtis Hughes
StreamLogic Inc.

Report •

August 10, 2006 at 16:25:14
One word of caution. Once you complete the above action you cannot remove the original column with the phone numbers or else you will lose the "new" numbers in the concatenated colum.

You can "break" the link between the cells so you don't have to keep the original by doing the following. 1) Select the colum with the new concatenated value, fromt he menu select Edit<Copy, 3) From the menu select Edit<Paste Special, 4) In the dialog box that comes up select the option "Value" in the top half and select OK.

The values int he new column will now include the area code but will no contain the formula from before and you can delete teh original phone number column.

Michael J

Report •

Related Solutions

Ask Question