Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and replace a value within a formula
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 -- FLYNNE |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and replace a value within a formula
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. FLYNNE wrote: 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 -- FLYNNE -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and replace a value within a formula
Thanks Dave
That worked perfectly - I had forgotten that * and ? acted as wild characters in searches. Thanks again -- FLYNNE "Dave Peterson" wrote: 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. FLYNNE wrote: 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 -- FLYNNE -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace Formula | Excel Discussion (Misc queries) | |||
Find Replace Formula | Excel Discussion (Misc queries) | |||
Find Replace Formula | Excel Discussion (Misc queries) | |||
Formula help! Find and replace in formulas | Excel Discussion (Misc queries) | |||
Find and Replace Formula Links | Excel Worksheet Functions |