In the Find and Replace dialog box, under Replace tab, please type ~* in the Find what box, type the Select the range where you will replace the tilde or wildcard characters, and press Ctrl + H keys to open the Find and Replace dialog box. Replace tilde and wildcard characters in Excel. In the Find and Replace dialog box, enter ~* into the Find what text box to find the cells which have the * character, and then type the value which you want to replace with in Replace with text box, see screenshot:
Go to click Home > Find & Replace > Replace or you can press Ctrl + H shortcuts to open the Find and Replace dialog, see screenshot: 3. Find and replace special characters in excel
