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

  • Thread starter Thread starter RJ
  • Start date Start date
R

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..
 
RJ said:
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
Click to expand...

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.
 
Back
Top