Change column number

S

S

I have forgotten how to do this.

=SUM(I12:I39,I42:I67,I70:I96,I100:I125,I128:I152,I157:I183,I186:I212,I215:I241,I246:I269)

I want to change the column `I` to `H` I seem to remember there was a way
to get this done automatically
but can`tremember how.

help please.
thanks
 
R

Rick Rothstein \(MVP - VB\)

One way... Copy the formula from out of your posted message into any blank
cell that has a blank cell to its left and paste it into that blank cell,
drag the formula cell left one column and copy what is in the formula bar
for the cell you copied it to, then paste that over the original formula.

Rick
 
D

Dave Peterson

Edit|replace???

I'd select an empty cell (using ctrl-click) along with this cell, too.
 
H

Harald Battran

Try the "search and replace" function. In your case it would just need
to search for the big "I" and replace it with the "H"

In other cases you might need to be a bit more distinct with the
search pattern. And you might even have to do two or more rounds.
Although not necessary in the example you could search ",I" replace
with ",H" and then search ":I" and replace with ":H". Just the very
first "I" you would then need to change manually.

Of course leave out the "

Should work
Harald
 
S

S

Thats what I was looking for the `search and replace`
How do I access that?
Used it before so must be on my PC.
 
Top