Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and replace multiple values
All;
Need to do a search and replace on multiple values: 06 - Phase VI would be replaced by O, 08 - Won would be replaced by W, 09 - Lost would be replaced by L, 10 - Cancelled by Gov't would be replaced by C I've looked for formulas, but what I've turned up is multiple values to one value e.g. $ or - to blank. Any help would be appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and replace multiple values
Well, the easiest way would be: Ctrl+F Replace Find what (type in your
criteria) Replace with (type in your criteria) Replace All. -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Rachel D" wrote: All; Need to do a search and replace on multiple values: 06 - Phase VI would be replaced by O, 08 - Won would be replaced by W, 09 - Lost would be replaced by L, 10 - Cancelled by Gov't would be replaced by C I've looked for formulas, but what I've turned up is multiple values to one value e.g. $ or - to blank. Any help would be appreciated! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace multiple values in one statement | Excel Programming | |||
Replace cell values in multiple columns | Excel Programming | |||
Control search/replace dialog startup values | Excel Programming | |||
How can I perform multiple search & replace - all data in spreadsheet? | Excel Programming | |||
Search multiple values to return single values | Excel Worksheet Functions |