Retrieving contents of wildcard match in search and Replace

  • Thread starter Thread starter ashish13
  • Start date Start date
A

ashish13

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?????????
 
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
| 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?????????
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find/Replace MSWord wildcard characters from within Excel 6
Percentile on filtered range 1
macro to insert function without parameters 6
Search & Replace 2
Using a variable in a formula 3
SumIF and STDEVIF is there a such thing 5
VBA Replace using wildcard? 3
Use intersection of column and TWO ranges in formula? 2

Back
Top