Replace Letter "E" with Letter "C" for 200 Different Sums in a Col

[Katherine]

Hi,

I have a series of different sums in the same column which contain the
correct row numbers but not the correct column letter (they contain "E" when
I want them to say "C"; e.g. =SUM(E10:E13) instead of =SUM(C10:C13)). Rather
than going through them one by one manually, is there a quick way to change
all the sums in that column to say "C" with their respective row numbers?

Thank you,
Katherine

 

[Michael]

Hi Katherine
Use Find and Replace for this problem.
If the formula is the same all the way down the column, say A1+B1, A2+B2,
etc, just change the first one then drag the new formula down as far as
required.

HTH
Michael