Use Paste Special, Add to combine data from 2 columns

Here are the steps to follow for this lesson:

1. Copy the data in the new column.
2. Select the top cell in the original column and click Paste Special, Add
3. To preserve any special formatting in the original column take this extra step:
4. Click Paste Special, Values, Add

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.