The CELL function can return the address of a cell.

=CELL("address",A1)

This returns the value: $A$1

You could manipulate this result to show just the column letter.

=MID(CELL("address",A1),2,FIND("$",CELL("address", A1),2)-2)

This would just return: A

HTH,
Elkar


"masterbaker" wrote:

This should be an easy one:

Is there a function that returns the name of the column (A,B,C,....) just
like there is one for row, but returns the static value of the column (A,B,C)
and not just a column number??

I can do it by setting up a table and associating 1 with A, 2 with B, and so
on...but that's anoying especially if I am expecting to go past the 26 letter
alphabet into the combinations.

Thanks for any help!!!