Hi,

A have raw data in column A that I would like to clean up. I would like a
macro to concatenate each row's data (add it to the end of the previous row)
with a space to precede it if the number of characters to the last space is
less than seven(7). I would then like to delete that row. I would like to
have this loop to the last row for column A.

Any help would be greatly appreciated.

Thank you.
--
By persisting in your path, though you forfeit the little, you gain the
great.