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
|