Any way to change all references to one column (in a cell) to another column?

  • Thread starter Thread starter ModelerGirl
  • Start date Start date
M

ModelerGirl

I have an array of cells that all refer to cells in column A (A30,A32
etc). I'd like to change all those references to C30,D32, etc.

Is there any way to do this? Because of other relative references i
the cells, just copying won't work.

Any help is greatly appreciated! Thanks again for all your help.

Kat
 
Your can use the Edit, Replace to do this. Example
highlight the cells to change, then in the 'Find what'
enter A30, in 'Replace with' enter C30, then A32 with D32
and so on.

Charlie O'Neill
 
Watch out for this:

If you have text in a cell that shouldn't be changed or even references to cells
like:

=C303 or =AC30

You may get more than you bargained for.
 
Back
Top