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

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
 
C

Charlie

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
 
D

Dave Peterson

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.
 
Top