Also, how would i go about taking the parsed overflow and pasting in
into the cell below (given that is empty or if it has text, insert a
new row right underneath the current one to paste it onto so no text
is loss)?

On Apr 27, 9:41*pm, Miguel wrote:
Thanks for the quick response Garry.
Well, the number of characters is determined by the size of the cell
in the spread sheet i am working with. I am working on XL07 and if the
cell is 546 pixels height by 442 pixels width = about 2170 characters