ExcelBanter - Excel Merging Issues

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Merging Issues (https://www.excelbanter.com/excel-discussion-misc-queries/95784-excel-merging-issues.html)

swtanjewel

Excel Merging Issues

How do I merge multiple columns without loossing each columns data?

Gord Dibben

Excel Merging Issues

In an empty column enter a formula.

=A1 & B1 & C1 & D1 entered in E1

Drag/copy down column E

If you want spaces between use

=A1 & " " & B1 & " " & etc.

When happy, select column E and Copy then EditPaste Special(in
place)ValuesOKEsc

Delete A through D

Gord Dibben MS Excel MVP

On Fri, 23 Jun 2006 12:57:02 -0700, swtanjewel
wrote:

How do I merge multiple columns without loossing each columns data?

swtanjewel

Excel Merging Issues

Thank you :)

"Gord Dibben" wrote:

In an empty column enter a formula.

=A1 & B1 & C1 & D1 entered in E1

Drag/copy down column E

If you want spaces between use

=A1 & " " & B1 & " " & etc.

When happy, select column E and Copy then EditPaste Special(in
place)ValuesOKEsc

Delete A through D

Gord Dibben MS Excel MVP

On Fri, 23 Jun 2006 12:57:02 -0700, swtanjewel
wrote:

How do I merge multiple columns without loossing each columns data?

All times are GMT +1. The time now is 04:43 AM.