|  | Change column number | | |
| | | S |  |
|  Posted: Sun Jul 13, 2008 5:36 pm Post subject: Change column number |  |
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 |
| |
| | | Rick Rothstein (MVP - VB) | |
| | Posted: Sun Jul 13, 2008 5:42 pm Post subject: Re: Change column number | |
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
"S" <virgin@blueyonder.co.uk> wrote in message
news:HOsek.74957$7v1.74891@newsfe30.ams2...
| Quote: | 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
|
|
| |
| | | Dave Peterson | |
| | Posted: Sun Jul 13, 2008 6:24 pm Post subject: Re: Change column number | |
Edit|replace???
I'd select an empty cell (using ctrl-click) along with this cell, too.
S wrote:
| Quote: |
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
|
--
Dave Peterson |
| |
| | | S | |
| | Posted: Mon Jul 14, 2008 5:41 am Post subject: Re: Change column number | |
Thats what I was looking for the `search and replace`
How do I access that?
Used it before so must be on my PC.
"Harald Battran" <harald.battran@googlemail.com> wrote in message
news:8c61dc79-444a-4c8d-9f5a-bc90787d7560@c65g2000hsa.googlegroups.com...
| Quote: |
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 |
|
| |
| | | Bob Phillips | |
| | Posted: Mon Jul 14, 2008 6:43 am Post subject: Re: Change column number | |
Ctrl-H
--
__________________________________
HTH
Bob
"S" <virgin@blueyonder.co.uk> wrote in message
news:_qDek.15601$Zm1.735@newsfe27.ams2...
| Quote: | Thats what I was looking for the `search and replace`
How do I access that?
Used it before so must be on my PC.
"Harald Battran" <harald.battran@googlemail.com> wrote in message
news:8c61dc79-444a-4c8d-9f5a-bc90787d7560@c65g2000hsa.googlegroups.com...
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
|
|
| |
| | | Harald Battran | |
| | Posted: Mon Jul 14, 2008 7:34 am Post subject: Re: Change column number | |
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 |
| |
|
|
