Excel formula: convert Roman numerals to regular Arabic numbers
Last year, I did a TikTok video blog post about Excel’s =ROMAN function (watch it here). It will convert any regular Arabic number to Roman. For example, =ROMAN(2026) will return MMXXVI. I noted that there is no built-in function to go the reverse direction. Thanks to Reddit user @real_barry_houdini, here