S
shark102
hello
i have following problem. i receive accounting data where description field
contains polish characters that get converted to unicode characters, eg:
- rezerwa _1007 za│oâ”enie
- 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
i have following problem. i receive accounting data where description field
contains polish characters that get converted to unicode characters, eg:
- rezerwa _1007 za│oâ”enie
- 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