Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
replace unicode characters
hello
i have following problem. i receive accounting data where description field contains polish characters that get converted to unicode characters, eg: - rezerwa _1007 zaoenie - rezerwa_1007rozwi£zanie - przeksiĪ©gowanie miĪ©dzy MPK i need to replace them with the most similar regular character eg. Ī© (unicode hex 2126) - with 'e' £ (unicode hex 2563) - with 'a' (unicode hex 2510) - with 'z' etc. i can do it by copying unicode character and performing find/replace from upper menu. but preferably i would need a macro to do that since whole document is edited by macro i wrote. replacing these characters is the only thing i got stumped. recording macro for find/replace does not work - unicode characters in recorded macro get replaced with something else - Ī© with O for example. thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I use macro to find and replace unicode characters | Excel Discussion (Misc queries) | |||
Need to convert Characters between Unicode and ANSI | Excel Programming | |||
inserting unicode characters | Excel Discussion (Misc queries) | |||
How do I enter Unicode characters in Excel? | Excel Programming | |||
Display unicode characters in non-English windows | Excel Programming |