| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
![James Silverton[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
