Multi cell to Multi line
Posted by Dale Coons on September 22, 2000 5:14 AM
I need to convert a 'horizontal' address book in
multiple cells into a single cell entry. Original
entries look like:
A B C D E
Coons Dale President TheCompany TheAddress
and I need to get it *in a single cell* to look like
this:
Dale Coons
President, TheCompany
TheAddress
I thought this might be possible using concatenation
and word wrap, but I don't seem to be able to force
a new line in word wrap. I tried using
=B1&" "&A1&CHAR(10)&C1....
but excel doesn't seem smart enough to break the line
instead of inserting the [] unprintable character box.
Anybody got a way to do this?