| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove top bit characters
I've an excel file that contains lots of top bit characters.
Ive found that I can replace linefeed chars using the replace tool and entering ALT 0010 but I'm still left with lots of unknown top bit characters - shown in Excel and Notepad as a rectangle in Times New Roman. Ive tried macros that remove CR's and LF's but I'm still left with the top bit chars! A sample can be found he http://fp.catshill.plus.com/excel.zip On a separate but related topic, is there a way to find the ASCII code from a top bit character? -- Brett |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove varying amounts of space characters | Excel Discussion (Misc queries) | |||
| remove non-numeric characters from a cell | Excel Discussion (Misc queries) | |||
| remove last three characters of cell | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Threaded Mode
