Lambda: Turn Excel formulas into custom functions
This is completely orthogonal to the full scope of LAMBDA, But it did make me laugh to see that the first example involved a classic and painful usecase (extracting 2 letters amid a string of numbers), which in Excel has to be written as:<p><pre><code>    =LEFT(RIGHT(B18,LEN(B18)-FIND("-",B18)),FIND("-",RIGHT(B18,LEN(B18)-FIND("-",B18)))-1)

</code></pre>
But if only Excel would support regular expressions like Google Sheets [0], could be done as easily as:<p><pre><code>    =REGEXEXTRACT(A2, "[A-Z]{2}")
</code></pre>
I'm sure adding regex isn't a trivial thing, but simple pattern extraction seems such an absolutely massive usecase for every everyday user that just I cannot fathom why Microsoft won't support regex. It would make Excel vastly more powerful for its purportedly non-coding users, especially since GSheets has had it for years now. Maybe someone on the product team believes regex feels too much like "code"? As a triple nested function involving subtr, strlen, and array indexing <i>isn't</i>?<p>[0] <a href="https://support.google.com/docs/answer/3098244?hl=en" rel="nofollow">https://support.google.com/docs/answer/3098244?hl=en</a>