How to find *,@,#,$,&,^ ??????

M

mala

I need to find and replace certain special cherecters like
*,@,#,$,&,%,^ etc and replace them with some reguler text. The problem
is that being special cherector VBA acts as if these are commands or
wild cherecters (like find vba.* will find allfiles with vba with any
extension)
Any workaround?
Please, I need it badly.
Regards,
 
F

Frank Kabel

Hi
use the ~ symbol to precede this character e.g. search for
~*
to find all occurences of *
 
Top