Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I use macro to find and replace unicode characters
I have database files that I import into Excel 2003. In certain columns
there are unicode characters, e.g. . I use the find and replace function to replace these charactrers with numbers. I can do this fine by hand. When I record a macro to do the same, it doesn't work. The macro replaces the characters with the plus sign "+" which breaks it. I've tried editing the macro by placing the characters in the formula, but that doesn't work either. The editor won't allow it, replacing the with a question mark "?". Does anyone know how I can get this to work. I do this almost daily I would hate to do it manually every time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace Special characters with numbers | Excel Discussion (Misc queries) | |||
FIND and REPLACE characters needed | New Users to Excel | |||
FIND and REPLACE characters needed | Excel Worksheet Functions | |||
How do I find replace special characters? | Excel Discussion (Misc queries) | |||
Find and replace unusual characters ... | Excel Discussion (Misc queries) |