Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving contents of wildcard match in search and Replace
IS there a way in the Replace part of Search and Replace to use any
wildcard match on the SEarch side verbatim... Let me explain... I have a bunch of cells where I have the formula Stdev(<Cell Range) Using Search and Replace, I want to use the Percentile Function instead of the Stdev function.. So I want to change the formula to Percentile(<Cell Range,0.8).. I tried searching for Stdev(*) but saying Percentile(*,0.8) in the Replace does not work Any ideas if this can be done????????? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving contents of wildcard match in search and Replace
You might try doing 2 replaces. First replace ")" with ",0.8)" and second
"stdev" with "percentile". Doing it in the other order creates an invalid formula error. -- Jim wrote in message ups.com... | IS there a way in the Replace part of Search and Replace to use any | wildcard match on the SEarch side verbatim... Let me explain... | | I have a bunch of cells where I have the formula Stdev(<Cell Range) | | Using Search and Replace, I want to use the Percentile Function instead | of the Stdev function.. So I want to change the formula to | Percentile(<Cell Range,0.8).. | | I tried searching for Stdev(*) but saying Percentile(*,0.8) in the | Replace does not work | | Any ideas if this can be done????????? | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use of Wildcard characters with replace | Excel Discussion (Misc queries) | |||
Doing a replace with a wildcard charcter | Excel Discussion (Misc queries) | |||
Wildcard search | Excel Worksheet Functions | |||
replace using wildcard, or else | Excel Discussion (Misc queries) | |||
help with a wildcard search | Excel Discussion (Misc queries) |