Mike wrote on Mon, 10 Nov 2008 10:50:05 -0800:

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,

Do you need a VB routine? A replace all could do it.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not