Works perfectly. Thanks so much!

I've been adapting your code to make various replacements and it does the job really well. I'm flying through the changes I need to code (except the complex stuff). The main "simple" thing I'm struggling with is finding and replacing Unicode characters. Specifically:

1. Replacing apostrophes after numbers with prime symbols, e.g. 3' -> 3′.

2. Replacing the string "space hyphen number" with the string "space minus sign number", e.g., -3 -> −3.

3. For percentage ranges written with 2 percentage signs and an en dash, delete the first percentage sign, e.g., 5%–30% -> 5–30%. I made this work for hyphens but not en dashes.

I've tried things like ".Text = ChrW(###)", with both hexadecimal and decimal codes, but I haven't been able to make .Find latch on to Unicode characters at all so far...