Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I use macro to find and replace unicode characters CliffG Excel Discussion (Misc queries) 13 April 2nd 09 07:44 PM
Need to convert Characters between Unicode and ANSI FcoMariscal Excel Programming 0 August 24th 06 10:47 PM
inserting unicode characters Wazooli Excel Discussion (Misc queries) 1 February 7th 05 06:54 PM
How do I enter Unicode characters in Excel? MacroAlan[_4_] Excel Programming 0 February 5th 05 08:25 PM
Display unicode characters in non-English windows Terence Excel Programming 1 October 10th 03 12:51 PM


All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"