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
|