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
Microsoft will remove the experimental =COPILOT function from the Excel beta. They said they want functions to be more dependable and precise.
Microsoft is now beta testing three functions to use regular expressions to identify, extract and replace text based on regular expressions. These can make easier and fine-tuned work of searching and replacing than current functions can. Since these are new in beta, you may have to wait a while until
In partnership with Experts Exchange. Another excellent feature Microsoft added to Excel is automatic calculations! It doesn’t mean you don’t have to write any formulas anymore, but it can figure out some of them for you, not just simple ones. If you’re familiar with Flash Fill, you might think of
In partnership with Experts Exchange. If you ever wanted to insert a checkbox in an Excel worksheet, you know it wasn’t easy or straightforward. But now it is! The Windows edition of Excel 365 now has a checkbox object you can insert just like a drawing object. You can apply
