View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default How to find *,@,#,$,&,^ ??????

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

--
Regards
Frank Kabel
Frankfurt, Germany

"mala" schrieb im Newsbeitrag
om...
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,