We will see how to find and replace “~” in excel.
As tilde is a special character in excel, it should be treated differently. A simple find operation in which you provide the “~” character won’t work.
Microsoft Excel uses the tilde (~) as a marker to indicate that the next character is a literal. When you use the Find and Replace dialog box to find or replace a character such as a tilde (~), you must add a tilde (~) before the character in the Find what box.
In this case we will have t provide two consecutive “~~” character.
Suppose we want to replace “~” tilde in our data with nothing, meaning we want to delete the tilde character from our data.
Press Ctrl+H to open the find and replace box in excel.
And enter “~~” in find what box and type nothing in replace box and click Replace All.
As you could see all the “~” asterisk character have been deleted.
You could also use any character or word you want to replace the “~” with.
Hope this helped.
