Cum se obține o literă de rând sau coloană a celulei curente în Excel?
Autor: SunUltima modificare: 2020-06-03
Ați încercat vreodată să obțineți rândul sau litera coloanei celulei curente în Excel așa cum este prezentat mai jos? Aici, introduc câteva formule pentru a obține rapid litera rând sau litera coloanei celulei active.
None of those listed solve this. What I posted here does, regardless of it be "A" "AA" "AAA"
Note, Column() can be used to point to any number for a column, i.e. Column(13) returns "M", Column(53) returns "BA", Column(712) returns "AAJ" but be sure to update both mentioned instances.
This comment was minimized by the moderator on the site
To get any Column Letter:
=MID(ADDRESS(1,COLUMN()),2,LEN(ADDRESS(1,COLUMN()))-3)
ADDRESS(1,COLUMN()) returns $A$1, $AA$1, $XFD$1, etc. based on lookup position put into the () of column part of equation.
LEN counts characters
MID gathers characters at starting position and count length from there. Start at 2 to eliminate the initial $ and go total LEN - 3 to get rid of ending $1 as well as the starting $ because we shifted our start position.