On Nov 20, 1:45*pm, Mel wrote:
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

why wouldn't Replace(Yr_Var, cstr(Chr$(8482)), cstr(Chr$(9674))) work?