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?