Fill Alphabet or Roman Numerals

January 12, 2025 ALL, BUSINESS, ENGLISH ARTICLES, MICROSOFT EXCEL TIPS 0

Fill Alphabet or Roman Numerals

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

softexperia.com

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)))

YouTube Link: https://youtu.be/5LaZA3rHPSs

#excel_tips_softexperia #excel_tips #softexperia