How to perform Search and Replace on "Tilde", CHAR(126), ~

[sgunther]

Hello

I am using Excel 2003.

It appears that Excel's search and replace function is ignoring the
tilde (~) character. I am simply trying to delete every instance,
within any character string or a single ~. I have tried the Search and
Replace function to no avail. The Substitute (=SUBSTITUTE(tilde,"~","",
1)) function works, but is at the single cell level or array level,
not the entire sheet or workbook. The CHAR(126) does return a ~.

Thank You,
Sean

 

[Beege]

Hello

I am using Excel 2003.

It appears that Excel's search and replace function is ignoring the
tilde (~) character. I am simply trying to delete every instance,
within any character string or a single ~. I have tried the Search and
Replace function to no avail. The Substitute (=SUBSTITUTE(tilde,"~","",
1)) function works, but is at the single cell level or array level,
not the entire sheet or workbook. The CHAR(126) does return a ~.

Thank You,
Sean

Sean,

Check out

http://support.microsoft.com/kb/214138

Beege

 

[Dave Peterson]

Use two of them.

* and ? are can be used for wildcards.

To actually find the asterisk and question mark, you use ~* and ~?.

And so to tell excel that you want to find ~ (not treat ~ as an "escape"
character for * or ?), you use two:

~~