Within hours, security researcher Chase Dardaman figured out a way to use Microsoft's new feature to load the CoinHive in-browser miner through a custom JavaScript Excel function.

You’ll use LAMBDA () functions the same way you use Excel functions. To demonstrate, enter the function and reference the values shown in Figure B, =SUBTRACTL (B3,C3).

Regular expressions aren't just for use in Excel. In fact, you can use REGEX to automate other tasks on your computer, like fixing copy-pasted PDF text, bulk-renaming downloaded files, formatting ...

If you’d like to learn about XLOOKUP (), read How to use the newish XLOOKUP () dynamic array function in Excel. I’m using Microsoft 365 on a Windows 10 64-bit system.