Precede the * with a tilde ~

find what: ~*

* is itself generally used as a "wildcard" in a search so needs the tilde to
tell Excel it is not.

Same if you were looking for ? which is also a wildcard.

You would look for ~?


Gord Dibben MS Excel MVP

On Thu, 29 Oct 2009 17:16:02 -0700, Donna wrote:

In my cells that contain partial sentences there are * used. I tried to use
find and replace to remove them but it will not recognize them. I assume
this is because this is a Microsoft multiplication operator. Is there a way
around this?
Donna