View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip[_3_] Chip[_3_] is offline
external usenet poster
 
Posts: 133
Default Combine cells and text wrapping

Somebody may have a cooler way of doing this, but try this...format the
cell so it does text wrapping:

Then do something like this:

=B1&" "&B2


And you just need enough spaces in between the quotes so it falls on
the next line. I dont think you can put in a return to the next line,
so this is a way to cheat.