View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Find and Replace Troubleshoot

Larraine,

You don't need the wildcard to find the - in 22-SRH059 simply put - in the
find box but I'm not clear from you post what you want to replace it with. If
you simply want to remove it leave the replace box blank.

Mike

"Larraine" wrote:

When I find and replace using an *, it replaces the actual text with an *
instead of replacing with the text that is already there. I can't figure out
what I am doing wrong.

Cell= 22-SRH059
Find= *-*
Replace= -*
Result= -*