Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove character at end of data | Excel Discussion (Misc queries) | |||
How to remove character format under .csv? | Excel Discussion (Misc queries) | |||
How to remove a character from the first index? | Excel Discussion (Misc queries) | |||
Remove a particular character using formulas | Excel Discussion (Misc queries) | |||
Unable to read accent character in a generated xml file | Excel Discussion (Misc queries) |