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