| | A | B | C |
| 1 |
## |
Ltr |
Formula |
| 2 |
1 |
A |
=LEFT(ADDRESS(1,A1,4),LEN(ADDRESS(1,A1,4))-1) |
| 3 |
2 |
B |
=LEFT(ADDRESS(1,A2,4),LEN(ADDRESS(1,A2,4))-1) |
| 4 |
3 |
C |
=LEFT(ADDRESS(1,A3,4),LEN(ADDRESS(1,A3,4))-1) |
| 5 |
11 |
K |
=LEFT(ADDRESS(1,A4,4),LEN(ADDRESS(1,A4,4))-1) |
| 6 |
12 |
L |
=LEFT(ADDRESS(1,A5,4),LEN(ADDRESS(1,A5,4))-1) |
| 7 |
13 |
M |
=LEFT(ADDRESS(1,A6,4),LEN(ADDRESS(1,A6,4))-1) |
| 8 |
23 |
W |
=LEFT(ADDRESS(1,A7,4),LEN(ADDRESS(1,A7,4))-1) |
| 9 |
24 |
X |
=LEFT(ADDRESS(1,A8,4),LEN(ADDRESS(1,A8,4))-1) |
| 10 |
25 |
Y |
=LEFT(ADDRESS(1,A9,4),LEN(ADDRESS(1,A9,4))-1) |
| 11 |
26 |
Z |
=LEFT(ADDRESS(1,A10,4),LEN(ADDRESS(1,A10,4))-1) |
| 12 |
27 |
AA |
=LEFT(ADDRESS(1,A11,4),LEN(ADDRESS(1,A11,4))-1) |
| 13 |
49 |
AW |
=LEFT(ADDRESS(1,A12,4),LEN(ADDRESS(1,A12,4))-1) |
| 14 |
50 |
AX |
=LEFT(ADDRESS(1,A13,4),LEN(ADDRESS(1,A13,4))-1) |
| 15 |
51 |
AY |
=LEFT(ADDRESS(1,A14,4),LEN(ADDRESS(1,A14,4))-1) |
| 16 |
52 |
AZ |
=LEFT(ADDRESS(1,A15,4),LEN(ADDRESS(1,A15,4))-1) |
| 17 |
53 |
BA |
=LEFT(ADDRESS(1,A16,4),LEN(ADDRESS(1,A16,4))-1) |
| 18 |
54 |
BB |
=LEFT(ADDRESS(1,A17,4),LEN(ADDRESS(1,A17,4))-1) |
| 19 |
55 |
BC |
=LEFT(ADDRESS(1,A18,4),LEN(ADDRESS(1,A18,4))-1) |
| 20 |
56 |
BD |
=LEFT(ADDRESS(1,A19,4),LEN(ADDRESS(1,A19,4))-1) |
| 21 |
57 |
BE |
=LEFT(ADDRESS(1,A20,4),LEN(ADDRESS(1,A20,4))-1) |
| 22 |
256 |
IV |
=LEFT(ADDRESS(1,A21,4),LEN(ADDRESS(1,A21,4))-1) |