View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shark102 shark102 is offline
external usenet poster
 
Posts: 16
Default 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 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