Paul Dalton, an attorney at a law firm, wrote that he needed a better way to clean up text spacing in documents. Using the Word macro recorder tool, Paul had already created a very extensive macro that found every instance of "X" and replaced each with "Y", such as changing one space at the end of a sentence to two spaces, over and over. In fact, that was the problem. The macro had become so large (well over 2000 lines) that it was getting out of hand.
Paul wanted a macro that would do the same thing with looping logic but he couldn't quite figure it out.
Paul's original recorded macro was similar to the code on the next page ...
