In a spare column (say E), to join A B C and D, in E1 put

=A1&" "&B1&" "&C1&" "&D1

and formula drag that down the column as far as your data goes.

Hope this helps.

--


Wrote:
Is there a way I can do this without having to create a macro? I
looking for something inbetween so I don't have to cut and paste,
thanks


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535482