Find and Replace Troubleshoot

L

Larraine

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

Mike H

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
 
L

Larraine

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)
 
S

Steven

If you want to simply strip the "22-" from your entry, then replace "22-"
with nothing.
 
R

Rick Rothstein \(MVP - VB\)

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
 
R

Rick Rothstein \(MVP - VB\)

Then the procedure I wrote about might not do what you want... it would
remove everything up to the last dash. So, if you had 123-ABC-DEF in a cell,
the procedure I gave you would leave DEF in the cell.

Rick
 
Top