Give this alternative a try -- it might just work for what you have over the
In say, B7, with B7 formatted to wrap text:
=SUBSTITUTE(TRIM(A7&" "&A8&" "&A9)," ",CHAR(10))
Adapt the part within TRIM to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"robnet" wrote:
I was hoping it would work, but it didn't. I got very strange formatting
results...I really want to thank you for your help! I learned something.