Find and Replace Troubleshoot

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

 

[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

 

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

 

[Steven]

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

 

[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

 

[Larraine]

Rick,

Thanks - what if there are 2 dashes in the cell?

 

[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