Function to get the column name of a cell?
How to get the column name of a cell?
For example what function can I use in the cell B3 so that the return value is the column name "B"?
First time here? Check out the FAQ!
How to get the column name of a cell?
For example what function can I use in the cell B3 so that the return value is the column name "B"?
Hello,
=REGEX(ADDRESS(ROW(),COLUMN(),4),"(.+)(\d+)","$1")
should work
Update According to @keme's comment (thanks for that)
=REGEX(ADDRESS(ROW(),COLUMN(),4),"([:alpha:])(\d+)","$1")
--or--
=REGEX(ADDRESS(1,COLUMN(),4),"([:alpha:])(\d+)","$1")
But anyway - solution using SUBSTITUTE()
and taking into account that row isn't important at all is much simpler.
Hope that helps
I found the solution
=SUBSTITUTE(ADDRESS(1;COLUMN();4);"1";"")
in another question: https://ask.libreoffice.org/en/questi...
Asked: 2020-06-04 23:09:52 +0100
Seen: 202 times
Last updated: Jun 04 '20
Alternating table column numbering, Col1 Numbers, Col2 Letters? [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]