How to convert names in formulas back to cell references

luket

New Member
Joined
Nov 29, 2005
Messages
2
If cell A1 is named 'dog' and cell A2 is named 'cat' and I have a formula in cell A3 that is '=dog+cat', does anyone know a quick way to get the formula to turn back to '=A1+A2'?

Thanks for the help...
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hi, welcome to the board!

How about Find and Replace?
 

luket

New Member
Joined
Nov 29, 2005
Messages
2
Good idea, but I am hoping for something quicker. I have a lot of formulas with a lot of different names.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,456
Members
412,595
Latest member
slim313
Top