That was brilliant! I can't thank you enough. I never would have thought to create the first column--ABAB--and without it the problem wouldn't have been any easier in Excel than it was in Word. You save me a lot of tedious work.