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