View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Finding and Replacing

Use ~* to find/replace *
~? to find/replace ?
~~ to find/replace ~


Jan wrote:

We have some descriptions of parts that have an * (asterisk) in them
We need to find and replace the asterisk with a space or a dash,
but since the * is a wildcard character find and replace will not work
Any Suggestions?


--

Dave Peterson