The escape character in Excel is the ~. So, to find and replace all asterisks, search for ~* and replace with nothing.

How do you remove asterisks from Excel cells?

1. Select the data range that you want to remove the asterisks. 4. And then click Replace All button, and all the asterisks have been removed from the cells.

How do I remove special characters from a cell in Excel?

Excel does not provide any functions to remove all special characters from strings at once. If you want to remove only one special character, you can use the SUBSTITUTE function (see more in this article remove-unwanted-characters).