Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
so basically I'm looking to do the following, which obv doesn't work...
Replace(string, Or("purge_", "dealdrop_"), "cor010_wcout") I've tried Replace(string, Array("purge_", "dealdrop_"), "cor010_wcout") which also doesn't work. since i'll never be in a situation where string will contain both purge_ and dealdrop_ I've gone the route of running the replace function twice as follows: tempstring = Replace(string, "purge_", "cor010_wcout") tempstring = Replace(string, "dealdrop_", "cor010_wcout") but there's Got to be a more elegant way than just trying to shove a square peg in a round hole with a big hammer... ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If AND/OR funciton with multiple criteria | Excel Worksheet Functions | |||
Multiple Conditional tests with Sumproduct | Excel Worksheet Functions | |||
Countif Using Multiple Logic Tests | Excel Worksheet Functions | |||
Multiple tests for a condition | Excel Programming | |||
Average a group of tests for grade, some tests not taken by all. | Excel Discussion (Misc queries) |