Using Wild Cards in the Replace line of Find & Replace

[Kappy]

Is this possible??

Consider a row that has many embedded formulas in it, including a formula that reads SUM(K54,K59,K70)... with the K being the letter of the column where the formula is.

I want to know if I can use "Find & Replace" to change this to:
SUM(K56,K63,K69)..

In the Find line of the menu, I can put in ?54,?59,?70 to find all iterations..

But what do I write in the Replace line???

using ?56,?63,?69 doesn't work, Excel thinks I want to change the column letter with an actual "?" (how dumb)

Any ideas?

Thanks

 

[Robert Mika]

Why do you trying to put the ? in of this numbers?
Simple:

K56,K63,K69
in Replace part works fir me.

 

[Kappy]

every column has a different letter in formula so I need the question mark to catch each iteration

 

[Steeviee]

you can just find & replace the numbers, ie. find 54, replace with 56, etc.

 

[Andrew Poulsom]

Sorry you can't do that. You can only use wildcard characters in the What box.

 

[Kappy]

steevie, yeah.. that's what I've had to do (though there are a ton more that need to be changed in my workbook than in the example I put up so its quite annoying).

andrew, thanks for the info... too bad