It happens that Miguel formulated :
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)?

There's a few ways to go about this...

1. You can iterate every cell in a column and test its contents
length.

2. You can set up a 'service' column that contains a formula that
returns the length, and iterate this for values '2170'.

I'm getting a sense that you're not all that familiar with using VBA
and so have to ask if you need this done for you by someone who's more
skilled?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc