Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace Troubleshoot
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= -* |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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= -* |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace Troubleshoot
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= -* |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace Troubleshoot
If you want to simply strip the "22-" from your entry, then replace "22-"
with nothing. "Larraine" wrote: 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= -* |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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= -* |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace Troubleshoot
Rick,
Thanks - what if there are 2 dashes in the cell? "Rick Rothstein (MVP - VB)" wrote: 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= -* |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace Troubleshoot
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 "Larraine" wrote in message ... Rick, Thanks - what if there are 2 dashes in the cell? "Rick Rothstein (MVP - VB)" wrote: 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= -* |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |