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

  • Thread starter Thread starter mala
  • Start date Start date
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,
 
Hi
use the ~ symbol to precede this character e.g. search for
~*
to find all occurences of *
 
GREEEEEEEEEEEEAT !
YOU DESERVE A BEER!!!!!!!!!!!!!!
THANKS A LOT.
REGARDS,
MALA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top