[pemfir]

I have a lot of data stored in one cell, they are all pulled using CONCATENATE function, I have separated the lines of data by char(10) (=CONCATENATE(E1,char(10),E2,char(10),. ), but when I wrap the cell that contains perhaps 60 lines of text, it does not let me see the entire content, I can only see the formula (=CONCATENATE(E1,. )) when I click on the cell

[JBeaucaire]

This should probably be in a thread of its own. Though your issue is similar, it's surely NOT an extension of the original thread.

Meanwhile, how about attaching a sample workbook pointing out the troublesome cells and perhaps what you would prefer to see a your "results", even if you have to mock them up manually on another "results" sheet.

Then click GO ADVANCED and use the paperclip icon to post up your workbook.

[ScottGem]

First its not a good idea to piggyback your question on someone else's. This can lead to confusion. You should start a new thread. So we've moved your question to its own thread.

Frankly, I wonder whether you are reaching the limits of Excel. I wonder why you are doing this.