Concaenate formula- text diff lines?

L

LJoe

Is there a way to make the CONCATENATE formula put all the text on different
lines? It keeps combining some on the same lines and I want them all on
separate- like a list. Thank you for your help!!

LJoe
 
H

havocdragon

Not sure exactly what you are asking, but to concatenate 2 lines is simply,

=concatenate(a1,b1)

Give us an example of what you are asking
 
S

starguy

right click on the cell your CONCATENATE function resides in, click
Format cell, Alignment tab, under text control check Wrap text then
Ok.
hopefully you will get what you want.
 
D

David Biddulph

LJoe said:
Is there a way to make the CONCATENATE formula put all the text on
different
lines? It keeps combining some on the same lines and I want them all on
separate- like a list. Thank you for your help!!
Click to expand...

=A1&CHAR(10)&B1
or
=CONCATENATE(A1,CHAR(10),B1)

You'll also need:
Format/ Cells/ Alignment/ Wrap text
 
L

LJoe

I am combining a3 to a10 with the formula. That is doing what I want it to
do, but I want it to appear in the cell as:

a3
a4
a5...etc like a list.

Right now, I have a3 to a10 all aligned left and all underneath eachother
before I do the concatenate formula. I want it to look like it does now,
just all in one cell. Does that clarify?
 
B

Beege

LJoe said:
Is there a way to make the CONCATENATE formula put all the text on
different
lines? It keeps combining some on the same lines and I want them all on
separate- like a list. Thank you for your help!!
Click to expand...

LJoe

"Wrap Text" may work, but if you include CHAR(10) between lines, it will put
the right stuff on separate lines, e.g.

=CONCATENATE(A1,CHAR(10),A2,CHAR(10),A3,CHAR(10),A4)

The CHAR(10) is a line feed code...

Beege
 
L

LJoe

Thank you Beege. It is just what I wanted.

Beege said:
LJoe

"Wrap Text" may work, but if you include CHAR(10) between lines, it will put
the right stuff on separate lines, e.g.

=CONCATENATE(A1,CHAR(10),A2,CHAR(10),A3,CHAR(10),A4)

The CHAR(10) is a line feed code...

Beege
Click to expand...
 
R

Rita

Help! I have tried this formula and the items appear on one line with an =
sign between the date
 
G

Gord Dibben

Rita

What date?

Show us a sample of your data and the formula you are using.


Gord Dibben MS Excel MVP
 
Top