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

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.

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.