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.