Thread: Multiple links
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Multiple links

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.