Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and replace "~"
Hello,
I'd like to remove "'#http://www.cfsan.fda.gov/~acrobat/" from a bunch of urls. It should be easy to do, except that Excel doesn't seem to recognize the "~" (the character below the escape key). Can someone help me? Thanks in advance, Ellen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and replace "~"
HI Ellen
Are you using Find& Replace in anycase try typing it twice like this ~~ HTH John "EllenM" wrote in message ... Hello, I'd like to remove "'#http://www.cfsan.fda.gov/~acrobat/" from a bunch of urls. It should be easy to do, except that Excel doesn't seem to recognize the "~" (the character below the escape key). Can someone help me? Thanks in advance, Ellen |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and replace "~"
use ~~
-- Gary''s Student - gsnu200829 "EllenM" wrote: Hello, I'd like to remove "'#http://www.cfsan.fda.gov/~acrobat/" from a bunch of urls. It should be easy to do, except that Excel doesn't seem to recognize the "~" (the character below the escape key). Can someone help me? Thanks in advance, Ellen |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and replace "~"
The tilde character is a special control character. To use it as a literal character, use two: "'#http://www.cfsan.fda.gov/!~~acrobat/" Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 29 Jan 2009 05:33:27 -0800, EllenM wrote: Hello, I'd like to remove "'#http://www.cfsan.fda.gov/~acrobat/" from a bunch of urls. It should be easy to do, except that Excel doesn't seem to recognize the "~" (the character below the escape key). Can someone help me? Thanks in advance, Ellen |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and replace "~"
"Chip Pearson" wrote in message
The tilde character is a special control character. To use it as a literal character, use two: "'#http://www.cfsan.fda.gov/!~~acrobat/" Cordially, Chip Pearson On Thu, 29 Jan 2009 05:33:27 -0800, EllenM wrote: Hello, I'd like to remove "'#http://www.cfsan.fda.gov/~acrobat/" from a bunch of urls. It should be easy to do, except that Excel doesn't seem to recognize the "~" (the character below the escape key). Can someone help me? As someone who has *used* Excel for a long time but is no expert, I was puzzled by why the double tilde had to be used. Thanks, Chip, for the explanation. -- James Silverton Potomac, Maryland |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and replace "~"
Just to add to Chip's response:
Excel can use wildcards in some functions and operations (edit|find, for example). * for any characters ? for any single character ~ as an "escape" character to indicate that the next * or ? should be treated as an asterisk or question mark--not as wild cards. So to find an asterisk, you use: ~* to find a question mark, you use: ~? to find a tilde, you use: ~~ James Silverton wrote: "Chip Pearson" wrote in message The tilde character is a special control character. To use it as a literal character, use two: "'#http://www.cfsan.fda.gov/!~~acrobat/" Cordially, Chip Pearson On Thu, 29 Jan 2009 05:33:27 -0800, EllenM wrote: Hello, I'd like to remove "'#http://www.cfsan.fda.gov/~acrobat/" from a bunch of urls. It should be easy to do, except that Excel doesn't seem to recognize the "~" (the character below the escape key). Can someone help me? As someone who has *used* Excel for a long time but is no expert, I was puzzled by why the double tilde had to be used. Thanks, Chip, for the explanation. -- James Silverton Potomac, Maryland -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and replace "~"
Thanks, everyone for your help!!
Ellen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
How do you Find and Replace the word "and" but not the and in "han | Excel Discussion (Misc queries) | |||
How to replace "#N/A" w "0"when vlookup couldn't find the match? | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) |