Change reference in formula from cell address to name

[hdf]

I'm fairly sure I saw this yesterday somewhere in this forum, but after
almost two hours of searching, and not finding, I figure I've earned
the right to ask - if only because someone should feel sorry for my
pathetic search skills (or bad memory).

Example: say I have a formula =$A$1+$B$2. Later, I name cell A1
"start" and B2 "finish". The original formula above still has the cell
references and not the cell names (it does not change to
=start+finish).

How can I get the formulae created prior to naming cells to change and
reflect the cell names?

Secondly, given that I have hundreds of formulas to which this would
apply, is there some way to do this globally or will I need to go cell
by cell?

Thanks,

Hector

 

[Ken Wright]

Edit / Replace / Replace what = $A$1, Replace with = Start will do all cells
that refer to A1

 

[hdf]

Thank you.

I was hoping there would be a simpler way to do it than the search and
replace approach. Since I have hundreds of cell names that I would
like to do this for, it could be quite a tedious task.

Is there another solution available?

 

[Niek Otten]

A bit dangerous, Ken; $A$15 will be converted to Start5

Use Insert>Name>Apply instead

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Edit / Replace / Replace what = $A$1, Replace with = Start will do all cells
that refer to A1

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission
-------------------------------------------------------------------------- --

 

[Debra Dalgleish]

Select the cells with the formulas
Choose Insert>Name>Apply
Select the names you want to apply
Click OK

 

[Ken Wright]

Oops - Cheers Niek - Should have thought of that one.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

A bit dangerous, Ken; $A$15 will be converted to Start5

Use Insert>Name>Apply instead

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel