Merging Columns in Excel XP

One way is to select a third column.
Enter the formula =A1&B1 (or =A1&" "&B1 to add a space). Extend the formula to fill the third column.
Select the third column and copy it. Select the "A" column (or just the first cell). Go to Edit>Paste Special and choose the values option.
You can now delete the contents of B and the third column.

OK, this is somewhat the long way around, but I think it will work.
1. Save the worksheet in tab-delimited text only format.
2. Open the text file in Word, and do a global search-and-replace to replace all the tab stops (^t) with the character of your choice, perhaps a space or two. Save your work and close.
3. Reopen the text file in Excel, and when importing with the Import wizard, specify Tab as the delimiter character. Since there are no tab stops anymore, everything will appear in a single column.
You can modify this as needed if you need to combine just one or two columns in a larger sheet and leave the others intact. You can also temporarily copy them to a separate sheet or workbook, do the merging, and then copy them back.

This question was auto closed due to inactivity