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

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

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

"Katherine" wrote:

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