| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to perform Search and Replace on "Tilde", CHAR(126), ~
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to perform Search and Replace on "Tilde", CHAR(126), ~
wrote:
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to perform Search and Replace on "Tilde", CHAR(126), ~
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: ~~ wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(ISERROR(SEARCH("insurance",A125,1)),"","*") | Excel Worksheet Functions | |||
| Perform a "Conditional Substitute/Replace" | Excel Worksheet Functions | |||
| How to replace "#N/A" w "0"when vlookup couldn't find the match? | Excel Discussion (Misc queries) | |||
| Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) | |||
| Can you replace "TRUE" with " " in an exact formula? | Excel Worksheet Functions | |||
Linear Mode
