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

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

Donna,
It's not because it's the multiplication symbol. Instead it is because it
is a "wildcard" that means "match anything in this position in my search
string". Another wildcard character is the question mark.

To search for an * in cells, precede it with the ~ (tilde) symbol, as ~*
will find an * in your entries. The ~ tells the Find function to take the
next character as a literal to find.

Hope this helps.

"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

Just to add (for the ~~):

If you want to replace an asterisk character, use ~* in the from string.
If you want to replace a question mark, use ~? in the from string.
If you want to replace a tilde (~), use ~~ in the from string.



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

--

Dave Peterson

Thanks that worked Great

"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