Find and replace a value within a formula

F

FLYNNE

In a worksheet there at least a 1000 cells containing the formula = Cell
reference*6.23 where cell reference is A1 , A2 , A3 etc.

I wish to change the value 6.23 in these formulae to 6.30 by using Find and
Replace.

If Find what = *6.23 and Replace with = *6.30 the formula in each cell
disappears and the contents of each cell becomes *6.30.

I of course could use

Find what = 6.23 and Replace with = 6.30 - this works but unfortunately
changes any cell value containing 6.23 in the worksheet which I wish to avoid.

Any suggestions please ?

regards

Flynne
 
D

Dave Peterson

The asterisk is a wildcard meaning any number of characters:

Try selecting the range to fix
Edit|replace
what: ~*6.23
with: *6.3
replace all

If you want to replace an asterisk character, use ~* in the from string.
If you want to replace a question mark, use ~? in the from string.
If you want to replace a tilde (~), use ~~ in the from string.
 
F

FLYNNE

Thanks Dave

That worked perfectly - I had forgotten that * and ? acted as wild
characters in searches.

Thanks again
 

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

Top