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?



Posted by Celia on September 22, 2000 6:15 AM

Dale
It should work if you select wrap text in the cell format.
Celia