View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_1159_] Rick Rothstein \(MVP - VB\)[_1159_] is offline
external usenet poster
 
Posts: 1
Default Find and Replace Troubleshoot

As long as there is ONLY **one** dash in your cells... select your cells,
call up the Replace dialog box, type *- (that is, asterisk followed by a
dash, nothing else) in the "Find what" field and leave the "Replace with"
field empty... click the "Replace All" button.

Rick


"Larraine" wrote in message
...
Mike,
I would like to replace 22-SRH059 with SRH059; however it is not always
SRH
- it could be any combination that is why I was using the * as a
replacement
value (to replace as is)

"Mike H" wrote:

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= -*