Do you want a macro?

It can be done without a macro using the ampersand.

=A1 & " " & B1 & " " & B2 & " " & B3


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 12:20:02 -0700, Lisa wrote:

Does anyone know a macro that would combine these cells into one?
Thanks in advance

Actual Output
10001 Need
Your
Help

10002 Thank
You in
Advance

Desired Output
10001 Need Your Help

10002 Thank You in Advance