View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_1165_] Rick Rothstein \(MVP - VB\)[_1165_] is offline
external usenet poster
 
Posts: 1
Default how to deal with "~"

Use two of them. If you are looking for AB~CD, put AB~~CD in the "Find what"
field.

Rick


"kelly" wrote in message
...
Hi, all

i have a problem to lookup or replace words when it contains "~"
character.
every time i have to change it to "-" manualy. for there are lots of
"~" in the workfile, too much time has been wasted on it.
Can anybody have any idea to solve this?

thanks