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

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.

"Max" wrote:

Perhaps you mean something like this instead:
=A7&CHAR(10)&A8&CHAR(10)&A9 ....
with " &CHAR(10)& " inserted in-between to pick up the Alt+Enters
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"robnet" wrote:
I double checked. Yes It is still enabled for the cells containing the
formula and the results cell.