Have you looked at the CONCATENATE function. Adding a space between each
cell-----

=CONCATENATE(A1," ",B1," ",C1," ",D1)

That way you don't even have to have adjacent cells.


"Anne Troy" wrote in message
...
It would take me a bit to figure out how to accomplish what you need most
efficiently. I imagine others feel the same way. The easiest way is to
provide a before and after. My first thought is that I would probably try
to do this using mail merge with Word.
************
Anne Troy
www.OfficeArticles.com

"evolart" wrote in
message ...

I'm really hoping this is possible, people keep viewing but not saying
anything at all. Is it not possible?


--
evolart
------------------------------------------------------------------------
evolart's Profile:
http://www.excelforum.com/member.php...o&userid=28129
View this thread:
http://www.excelforum.com/showthread...hreadid=476514