Hi,

Download and install this addin -
http://www.download.com/Morefunc/300...-10423159.html and then you can
use the MCONCAT() function

=mconcat(D132:D146," ")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tservo" wrote in message
...
I would LOVE to combine cells from the same column instead of cut &
pasting
information. - example D132 through D147 and have this combined
information
appear in D132. Is this possible?