Substitute works on data, not formulas. Use the Replace command to change
formulas. The actual steps required depend on your version of Excel. As
always, identifying the version of Excel you are using will help you get
more accurate answers, especially when they are urgently needed.

Regards,
Fred

"Tami" wrote in message
...
sorry for the urgency but i thought i posted this message yesterday
afternoon
and assumed that i could make some headway this am...but it doesn't appear
to
have posted.

Question:
is there a way to convert a forumula that looks like this =a1+a2+a3 to
Max(a1,a2,a3)? also can i convert =sum(a1:a3) to max(a1:a3).

in the first case it has 3 entries, in another instance it might have 4,
5,
etc.

do i use the subtitute function?