Excel 200 search for wildcard characters

  madwab 09:49 10 Jun 2004
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 2004

In the find box enter

~****

  madwab 10:56 10 Jun 2004

...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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?