I have a spreadsheet where there is a long list of part numbers that
constantly change, get added to, deleted from, etc. and all need to be in one
cell. The problem I have is that the list gets very long and needs to almost
be treated like the COLUMN feature in Word where you can take a long list
and make it read like 3 newspaper columns. Otherwise, each row is way way
too long and the data is on multiple pages when it actually needs to be on
one page and taking up minimal area. Is there any way to do that in one cell
in Excel?

Second part related to the first part above is that after items are
added/deleted to this long list, the remaining info needs to be sorted and
read correctly. This is a weekly report that i will be updating constantly
and not sure how to best approach it - or if there is even a way to do what i
am asking.

The ultimate goal is to have one cell with multiple pieces of data that read
like newspaper columns that I can sort from a to z and always have it fit in
the smallest space in one cell and stioll be readable.
--
Thx - M