Cell name

[mattflow]

Lets say cell A1 is named "Cheeseburger", what is the easiest way t
delete the name so that cell A1 is now simply A1

 

[mattflow]

Also meant to add that you have multiple cell referencing A1 a
"Cheeseburger" in their formula and not "A1"

 

[Shan]

i thought we press "DELETE" button in the keyboard to delete any entry .

 

[CLR]

Insert > Name > Define > select "Cheezeburger" in the lower window > Delete

Vaya con Dios,
Chuck, CABGx3

 

[mattflow]

Pressing "DELETE" wont accomplish what i am trying to get done. If
press delete then the cells referencing the cell "Cheeseburger" wil
still reference "Cheeseburger" and not "A1", however the cell will jus
have the value 0 (since i deleted its contents). And deleting the nam
"Cheeseburger" in the cell name box does absolutely nothing

 

[mattflow]

Thanks Chuck, but when I do this then the cells referencin
"Cheeseburger" still reference "Cheeseburger", so while deleting th
cell in this way does fix one problem, it then leaves me with man
name? errors.

Insert > Name > Define > select "Cheezeburger" in the lower window
Delete

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

BEFORE eliminating the Cheezeburger, do a "Fnd and Replace" to get it out of
the formulas and replace it with A1

Vaya con Dios,
Chuck, CABGx3

 

[mattflow]

Thanks Chuck, that seems to be the easiest way to do it

 

[CLR]

You're welcome, happy to be of help

Vaya con Dios,
Chuck, CABGx3