Fill Alphabet or Roman Numerals

Fill Alphabet or Roman Numerals

Sure, Excel can fill January, February, March, but what about A,B,C or I,II,III?

Drag down E7 = CHAR(ROW(65:65)

Drag down F7 = ROMAN(ROW(1:1))

Number Character Roman

1 A I

2 B II

3 C III

4 D IV

5 E V

6 F VI

7 G VII

8 H VIII

9 I IX

10 J X

11 K XI

12 L XII

13 M XIII

14 N XIV

15 O XV

16 P XVI

17 Q XVII

18 R XVIII

19 S XIX

20 T XX

21 U XXI

22 V XXII

23 W XXIII

24 X XXIV

For the upper case alphabet, use a formula of =CHAR(ROW(65:65)) and copy down.

For the lower case alphabet, use =CHAR(ROW(97:97))

For upper case Roman numerals: =ROMAN(ROW(1:1))

For lower case Roman numerals =LOWER(ROMAN(ROW(1:1)))

Κατανόηση Τύπων Διοίκησης