For Converting =sum(a1:a3) to =Max(a1:a3)
Select the range and press Cntrl+H in Find what box: mention SUM and in
Replace with: type MAX and give Replace All. Now the Sum function will be
converted to Max function.

For Converting =a1+a2+a3 to =MAX(A1,A2,A3)
Select the range and press Cntrl+H in Find what box: mention = and in
Replace with: type =MAX( and give Replace All. Now the Sum function will be
converted to =MAX(A1+A2+A3)
Again in Find what box: mention + and in Replace with: type , (comma) and
give Replace All. Now the =MAX(A1+A2+A3) will be converted to =MAX(A1,A2,A3).

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Tami" wrote:

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?