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

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.

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.