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