Thanks a lot, Graham. I've tried a couple of different major approaches (one approach is Find; 2nd approach is to have the macro look at each word). I'm going to try to figure out which approach is best (or whether a combo is necessary). I think you're right that it'll probably take a couple of searches with the Find. No matter which approach I find works best, I still am very curious as to how to know when the string found by the Right function is any UPPERCASE letter--i.e., what to use between the quotes (after the '=' sign) in the Right function. Thanks again.
|