Column numbers to letters

[Motiss]

The function COLUMN() translates column’s names (letters) to numbers (For example, =COLUMN(AA:AA) will return 27

Is there a function doing the opposite? I need a function like =NUMBER2COLUMN(28) that would output "AB" for example

Thanks!

[PKG]

@Motiss

I need a function like that would output for example=NUMBER2COLUMN(28) "AB"

=SUBSTITUTE(ADDRESS(1;28;4);1;"")

[LeroyG]

@PKG

;28;

;COLUMN(); to give the header of the actual column.

[Motiss]

Thanks a lot!

[karolus]

Hallo
Did you know that, for Example:

=INDEX($A$1:$XFD1000; 3 ; 28 )

returns the Content of Cell AB3

[LeroyG]

Calc convert this formula to =INDEX($1:1000; 3 ; 28 ), given that A:XFD are all the columns.
(LibreOffice 7.6.7.2)

[Motiss]

I didn’t know that. It indeed is pretty useful. Thanks!