can you mass replace formulas in excel?

[GoingUp]

I have one column with about 20 values of averages computed from different data. All I want to do is to copy the data to the next column over and replace the Average(x,x,x,x,x,x,x) with Max(x,x,x,x,x,x,x)

Is there any easy way to do this?

 

[WW]

replace will work in formulas, but if you simply copied the column to the next column excel would change the references (unless you used absolute references ($a$1) in your formulas)....

hmmm...how about show formulas in excel (ctrl `), then copy the column, paste in to ms word (or whatever), do a search and replace in the word processor (average to max), then copy that back into excel.

then ctrl ` back to show values

 

[Razorbacks]

If it is just the AVERAGE you want to replace with MAX, why not do a find-replace?