Find and replace "~"

[EllenM]

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

 

[John]

HI Ellen
Are you using > Find& Replace in anycase try typing it twice like this ~~
HTH
John

 

[Gary''s Student]

use ~~

 

[Chip Pearson]

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)

 

[James Silverton]

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

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.

 

[Dave Peterson]

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: ~~

 

[EllenM]

Thanks, everyone for your help!!

Ellen