Excel 200 search for wildcard characters

  madwab 09:49 10 Jun 04
Locked

I have a set of large spreadsheets with some cells that contain "****". I need to be able to find them but, amazingly, Excel 2000 doesn't seem to have the ability to turn wildcard searching off. Can this be done without writing a macro, or without modifying the sheets (eg with a simple "if(find("*"..." etc)?

Thanks

  VoG II 10:20 10 Jun 04

In the find box enter

~****

  madwab 10:56 10 Jun 04

...yet even knowing it, I can't find it in help. Anyway, it works - many thanks!!

This thread is now locked and can not be replied to.

Amazon Fire HD 8 review: A brilliant combination of function and value – with one massive caveat

1995-2015: How technology has changed the world in 20 years

How to create an introvert-friendly workplace

Apple Watch 2 review | Apple Watch Series 2 review: New Apple Watch is faster, brighter, water-resit…