View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
James Silverton[_3_] James Silverton[_3_] is offline
external usenet poster
 
Posts: 119
Default 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