View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mel[_4_] Mel[_4_] is offline
external usenet poster
 
Posts: 50
Default How do you work with high character numbers?

I've worked with characters such as Chr$(187) and such but now I have
to insert or search/replace a character that has a much higher number
in the mapping, such as Chr$(9674), which is a diamond looking symbol
("lozenge"). Excel errors with such numbers but runs fine with a lower
number.

How can I do a search for Chr$(8482) and replace with Chr$(9674)?

(These character numbers came from seeing them in an insert symbol
macro recording in Word. Character Map shows them as U+2122 and U+25CA
respectively.)

Thanks a bunch,
Melina