I need to do a find and replace where I find "*2" and replace with "/0.6".
How do I tell excel I want to find the actual asterisk rather than any string
of any length?

Use the tilde

Find: ~*
Replace with: /0.6

"GoBobbyGo" wrote:

I need to do a find and replace where I find "*2" and replace with "/0.6".
How do I tell excel I want to find the actual asterisk rather than any string
of any length?

Try:

Find what: ~*2

--
Biff
Microsoft Excel MVP


"GoBobbyGo" wrote in message
...
I need to do a find and replace where I find "*2" and replace with "/0.6".
How do I tell excel I want to find the actual asterisk rather than any
string
of any length?

Oops.. Find: ~*2

"GoBobbyGo" wrote:

I need to do a find and replace where I find "*2" and replace with "/0.6".
How do I tell excel I want to find the actual asterisk rather than any string
of any length?

Use the tilde

~*2

--


Regards,


Peo Sjoblom

"GoBobbyGo" wrote in message
...
I need to do a find and replace where I find "*2" and replace with "/0.6".
How do I tell excel I want to find the actual asterisk rather than any
string
of any length?