Concatenating data on a new line(within the same cell)

[RJ]

I'm trying to concatenate 3 lines of a product description
into one cell.. So of course i'll use something like
=A1&A2&A3, but i need there to be new lines between each
insert. So if i looked at a cell the product description
would look like..

 

[Jason Morin]

=A1&CHAR(10)&A2&CHAR(10)&A3

Make sure you select "Wrap text" for the cell under Format

Cells > Alignment.

HTH
Jason
Atlanta, GA

 

[Anon]

I'm trying to concatenate 3 lines of a product description
into one cell.. So of course i'll use something like
=A1&A2&A3, but i need there to be new lines between each
insert. So if i looked at a cell the product description
would look like..

------------------
A1 |
A2 |
A3 |
------------------

Any help is appreciated!

- RJ

Why do you want to do this? It's usually a really bad idea! For printing,
define your own borders rather than printing gridlines and it looks just
the same.

However, if you really must, you could use
=A1&CHAR(10)&A2&CHAR(10)&A3
and format the cell to wrap text.