Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|