In Excel 2003, when a cell has been mistakenly named as illustrated above, you can delete it.
Select the cell, go to Insert > Name > Define and click on the name you wish to be removed. Once removed, you can type in the correct name for your cell in the Name Box.
In Excel 2007, click the Formula tab, in the Defined Name group, click Name Manager.