How to find and replace the character "*" in Excel

Find and Replace (CTRL + H)

Search for ~*

Replace with whatever.

Cheers!


If you are doing this in code, you can look for CHAR(42), which is the numeric code for the * symbol.

Depending on how you do it, you should even be able to use the CHAR(42) in a worksheet formula.