Print cell with a ton of text

I'm building a form and there's one section where the user will likely copy and paste a huge block of text from word or similar into excel. My eventual goal is getting this to print, but at the moment I can't even get all the text to show in a single cell (Excel won't allow me to expand the cell by width or height enough to show all the text). I've also tried text boxes, but those cut off very early compared to just a cell. To give you an idea, I did a len() on the cell and it's about 6000 characters.

Any idea how I could get this to show up and print on a page? I have several macros in this file already so I've got no problem adding another. I was thinking I could parse through the text looking for carriage returns then separate the paragraphs into different cells. I thought someone else might have a better idea than parsing through it.

Thanks in advance for the assistance!

Chris

Hi Chris

If you're using Excel 2003 or earlier see this link...
http://excel.tips.net/T003163_Charac...for_Cells.html

If Excel 2007 or later, this link..
http://excelribbon.tips.net/T010231_...for_Cells.html