For once in my life, I actually had a delightful interaction with an LLM last week. I was changing some text in an Excel sheet in a very progromatic way that could have easily been done with the regex functions in Excel. But I'm not really great with regex, and it was only 15 or so cells, so I was content to just do it manually. After three or four cells, Copilot figured out what I was doing and suggested the rest of the changes for me.

This is what I want AI to do, not generate wrong answers and hallucinate girlfriends.

Thanks for reminding me to check if the REGEXEXTRACT, REGEXREPLACE, and REGEXTEST functions had landed for me yet. They have! Good, because sometime in 2027 the library providing RegEx in VBA will be yanked. https://youtu.be/pGH9LdgkJio