Awesome thanks! It worked really well for the English texts. I'm also doing a few in Greek. Usually the only changes that need to be made between the two are replacing the English letters with ChrW(###) statements for the Greek letters I need. VBA can't handle the Greek directly so I've been using ChrW and the unicode numbers of the Greek characters. Just subbing in ChrW(###) for the letters doesn't seem to be working in this case. Any insights? I'm super impressed with your code by the way. I'm an industrial engineering student so my programs are still pretty clunky.