You have your answer using address, but

=Substitute(CELL("address"),"$","")

------------------

CHAR(64+CELL("col",A1)))&CELL("row", A1)

would always return A1
--
Regards,
Tom Ogilvy

"yarp" wrote in message
...
The $ signs.
I don't think most people would use $ signs in cell names when they create
a
lookup table such as:
A1 30
A2 45
B1 28
B2 32
etc.
I'd be happy to know the reasons the address is returned with $ signs, but
even then, I think that adding a possible value to the info_type is most
welcome.
PS: It may be a nice exercise to try to get with Excel functions from an
address containing $ signs to an address without $ signs...


"Peo Sjoblom" wrote:

What's wrong with

=CELL("address")



--
Regards,

Peo Sjoblom

(No private emails please)


"yarp" wrote in message
...
CELL() function can return various data about the current cell, but
not
its
name. It does, however, return row and column serial numbers, so If I
want
to
lookup some cells in another table that contains their names, I have
to
use
this:
(CHAR(64+CELL("col",A1)))&CELL("row", A1)
(assuming that the column names have only 1 letter).
I suggest adding a possible value to the info_type argument of the
function
CELL():
"name" - Text value containing the name of the cell, for example: C19.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click
the "I
Agree" button in the message pane. If you do not see the button,
follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...lic.excel.misc