remove Acute Accent character '00B4'

[Mike Molyneaux]

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

 

[James Silverton]

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

 

[ShaneDevenshire]

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.

 

[Mike Molyneaux]

Worked great - thanks a million.
--
Mike

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.