I only recently graduated past Excel 2003 and didn't even know I could find-and-replace formatting like this; so first I trotted off and confirmed that. Then I thought the problem was that you can't replace text without changing it in some way—you can't change "x" to "x"—but no, that works too. In fact, if you're saying that "gmail" is the one word your Excel won't change, I'm sorry but it's working alright for me. If you'll attach the actual workbook, maybe we'll be able to figure out something.
|