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