Change column number

  • Thread starter Thread starter S
  • Start date Start date
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
 
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
 
Edit|replace???

I'd select an empty cell (using ctrl-click) along with this cell, too.
 
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
 
Thats what I was looking for the `search and replace`
How do I access that?
Used it before so must be on my PC.
 
Back
Top