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
|