find asterisk

[GoBobbyGo]

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?

 

[Sean Timmons]

Use the tilde

Find: ~*
Replace with: /0.6

 

[Sean Timmons]

Oops.. Find: ~*2

 

[T. Valko]

Try:

Find what: ~*2

 

[Peo Sjoblom]

Use the tilde

~*2

--


Regards,


Peo Sjoblom