This is what the formula looks like:

=WORKSHEET1!M27 & CHAR(10) & WORKSHEET2!M27 & CHAR(10) & WORKSHEET3!M27 &
CHAR(10) & WORKSHEET4!M27 & CHAR(10)

The cell that is wrap text formatted thats suppose to contain all the data
in a list has more empty space than data. The empty space pushes the data of
sight.



"JLatham" wrote:

Format the cell to Wrap Text and make it taller to begin with. It would
probably help to see the formula that is in the cell at this time.

If this is a simple concatenation of several other locations, like
= A5 & B99 & D4 & Z14
then if you'll write it as
= A5 & CHAR(10) & B99 & CHAR(10) & D4 & CHAR(10) & Z14
the & CHAR(10) portions will force a new line at each of them, and with word
wrap turned on, they will appear as a list.

If you're using the CONCATENATE() function then it would be like:
=CONCATENATE(A5,CHAR(10),B99,CHAR(10),D4,CHAR(10), Z14)


"jelm" wrote:

I have information coming from multiple links into one cell but would like
this information to be a list. As of now, the information is all over the
cell, not in any order. Any suggestions would be appreciated.