Worked great - thanks a million.
--
Mike


"ShaneDevenshire" wrote:

Hi,

0. Copy one of the accents
1. Select all the sheets (Shift click the sheet tabs)
2. Press Ctrl+H
3. In the Find what box press Ctrl+V
4. In the Replace with box enter a regular quote
5. Click Replace all.

--
Thanks,
Shane Devenshire


"Mike Molyneaux" wrote:


Excell 2003, XP Pro.

A user downloaded data from the internet that uses the Acute Accent
character instead of a standard single quotation mark. Sometimes. They are
mixed in with the single quote and make sorting the data & matching it to a
master database nearly impossible.

How to I write a vb routine to find and remove these things?

Thanks,

Mike