remove Acute Accent character '00B4'
 

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

remove Acute Accent character '00B4'
 

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

remove Acute Accent character '00B4'
 

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

remove Acute Accent character '00B4'
 

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