View Single Post
  #1   Report Post  
Katherine
 
Posts: n/a
Default 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