Excel contains about 500 worksheet functions. We all know about SUM and COUNT and VLOOKUP and all the other commonly used functions. But out of those 500 there are just as many functions that have obscure use cases and two of those functions, ROMAN and ARABIC, are what I cover in this video.
ROMAN converts a normal number (often called an Arabic Number) into a ROMAN numeral and ARABIC goes the other way, converting a Roman Numeral into a normal number.
Now I will admit, converting numbers to Roman Numerals and Roman Numerals to numbers probably isn’t the most useful of features in Excel, so I did struggle a little bit to come up with meaningful demos but if you’re interested to see what I came up with, check out the video below.
These are the formulas that I used in the demos…
=ROMAN(A2)
=ARABIC(B2)
=ARABIC(IFNA(TEXTAFTER(B2,” “),”I”))
BTW the 3rd one extracts the Roman Numeral from a longer string within a cell (for example Henry VIII) and converts it to a number.
Download a copy of the file(s) used in this video: https://share.zight.com/P8uKGdKg