Changing the Column letter in a list of cell link

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

I have a long column of cells that include links to other cells from
another sheet. I now want to put more links in my spreadsheet from
the same page. The links will correspond in row number, but will have
a different column letter. I know how to copy the links to another
column....and I will then get the same row number and a different
column letter. But it is not the column letter I want. Is there a
way I can change the column letter in all the cell links without going
through it individually? Thanks.
 
Vince

Could you possibly Edit>Replace?

Replace what: D
Replace with: Q

Gord Dibben Excel MVP XL2002
 
Back
Top