Have you tried turning on the macro recorder and doing it manually? This
might be the easiest. (Edit=Replace) (macro recorder:
Tools=Macro=Record a new macro). Then turn off the macro recorder and
look at the recorded code. You can then make substitutions as appropriate.

--
Regards,
Tom Ogilvy

"Raina" wrote in message
...

I would like to code a macro such a way that it searches the specified
cherecters say "yU" (without quats case sensitive) in whole or part of
a cell and replace it with the given cherecters.

Find :
&K}
font is Punjabi
case sensitive
whole or part of cell

Replace :
yU
Font wingdings
case sensitive
size same as previous.

It should be replaced only if all the above conditions (Find) are met
with.
Find string can be any combinations of english cherecters available
directly on the keyboard including special cherecters.
May be one of the experts or Gurus here can show me a way.

This is basically a mapping for a local language from english.
Thanks.
Raina


--
Raina
------------------------------------------------------------------------
Raina's Profile:
http://www.excelforum.com/member.php...o&userid=15502
View this thread: http://www.excelforum.com/showthread...hreadid=270759