View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Challenging formatting formula

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.