Concaenate formula- text diff lines?
 

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

Concaenate formula- text diff lines?
 

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

"LJoe" wrote:

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

Concaenate formula- text diff lines?
 

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.

LJoe Wrote:
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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=563718

Concaenate formula- text diff lines?
 

"LJoe" wrote in message
...
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!!

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

You'll also need:
Format/ Cells/ Alignment/ Wrap text
--
David Biddulph

Concaenate formula- text diff lines?
 

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?

"havocdragon" wrote:

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

"LJoe" wrote:

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

Concatenate formula- text diff lines?
 

"LJoe" wrote in message
...
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

"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),A 4)

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

Beege

Concaenate formula- text diff lines?
 

Thank you so much, works great!

"David Biddulph" wrote:

"LJoe" wrote in message
...
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!!

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

You'll also need:
Format/ Cells/ Alignment/ Wrap text
--
David Biddulph

Concatenate formula- text diff lines?
 

Thank you Beege. It is just what I wanted.

"Beege" wrote:

"LJoe" wrote in message
...
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

"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),A 4)

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

Beege

Concatenate formula- text diff lines?
 

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

"LJoe" wrote:

Thank you Beege. It is just what I wanted.

"Beege" wrote:

"LJoe" wrote in message
...
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

"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),A 4)

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

Beege

Concatenate formula- text diff lines?
 

Rita

What date?

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


Gord Dibben MS Excel MVP

On Tue, 12 Jun 2007 17:37:02 -0700, Rita wrote:

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

"LJoe" wrote:

Thank you Beege. It is just what I wanted.

"Beege" wrote:

"LJoe" wrote in message
...
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

"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),A 4)

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

Beege