General discussion

Locked

Merging Columns in Excel XP

By Stephen ·
Let's say that I have text data in Column A and text data in Column B. I am looking for a way to merge both columns so that all data is in column A and there is a blank Column B. Any ideas?

stephendavis@libero.it

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Merging Columns in Excel XP

by DKlippert In reply to Merging Columns in Excel ...

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.

Collapse -

Merging Columns in Excel XP

by Stephen In reply to Merging Columns in Excel ...

The question was auto-closed by TechRepublic

Collapse -

Merging Columns in Excel XP

by Faithe Wempen In reply to Merging Columns in Excel ...

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.

Collapse -

Merging Columns in Excel XP

by Stephen In reply to Merging Columns in Excel ...

The question was auto-closed by TechRepublic

Collapse -

Merging Columns in Excel XP

by Stephen In reply to Merging Columns in Excel ...

This question was auto closed due to inactivity

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums