Thanks Mark,
I just noticed that the text that I was trying to put into a single
cell was around 17,000 + characters and this is when I was getting Out
of Memory Error 7, this is less than the maximum limit of 32,767
characters. Is there any particular reason I was getting this error
well below the max value.

Regards