Jump to content

Merging Two Columns into One in Excel


Recommended Posts

Merging Two Columns into One in Excel

I need to add an area code to a column of phone numbers stored in an Excel 2002 worksheet. The area code is the same for all the numbers. Is there a way to add it without having to edit each phone number?

Assuming the phone numbers are in column A starting in row 2, select column A and choose Insert | Columns to insert a new column A and move the phone numbers to column B. Next, enter the area code in A2 and copy it as far down the column as needed. Now insert a new column as column C. In C2, enter the formula


This tells Excel to join the area code in A2 with a hyphen, followed by the phone number in B2. Here again, copy the formula as far down column C as needed. Next, select column C, choose Edit | Copy, then Edit | Paste Special, then Values and OK. This pastes the cell contents (not the formulas) back into column C. You can now delete columns A and B.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...