replacing asterisks

B

Biff

Try this:

Find what: ~*
Replace with: nothing - leave blank

Biff
-----Original Message-----
I have a 3600 row sheet and I need to remove the
asterisks (*) from about 950 scattered cells. However,
Excel won't let me. If I try, it reads the * as the old
DOS wildcard and removes EVERYTHING. It won't let me put
quotes around it either. Any suggestions would be
appreciated.
 
Top