Displaying the column letter

[jeshkhol]

The function =COLUMN() returns the column number of a cell reference. For example, =COLUMN(C58) returns 3.

What formula can I use to have the column letter (in the example above, C) returned instead?

[dscheikey]

You can use this formula:

=REGEX(CELL("ADDRESS"),"\w+")

Respectively:

=REGEX(CELL("ADDRESS",C58),"\w+")

[sokol92]

Or transferable to Excel:

=SUBSTITUTE(ADDRESS(1;COLUMN(C58);4);"1";)