The ASK.AI function is available only with Modern Functions Update (MFU). You can now run it for free on your Excel from 2007 onward, including 2024 and 365. Description The ASK.AI function lets you ask any question in natural language, and the AI — powered by an external AI, like Ollama (local, offline AI) or OpenAI (ChatGPT) via API — will return an answer. … Read more
The REGEXREPLACE function is officially available only on Excel 365, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013, 2016, 2019, 2021 and 2024 versions. It works exactly as its original Microsoft counterpart. Description The REGEXREPLACE function replaces all or part of a text string that matches a regular expression (“regex”) pattern … Read more
The REGEXEXTRACT function is officially available only on Excel 365, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013, 2016, 2019, 2021 and 2024 versions. It works exactly as its original Microsoft counterpart. Description The REGEXEXTRACT function extracts text from a string based on a provided regular expression pattern. For the advanced … Read more
The REGEXTEST function is officially available only on Excel 365, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013, 2016, 2019, 2021 and 2024 versions. It works exactly as its original Microsoft counterpart. Description The REGEXTEST function checks whether any part of the supplied text matches a regular expression (“regex”) pattern. It … Read more
The TEXTAFTER function was officially introduced with Excel 2021, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013, 2016, 2019 and 2021 versions. It works exactly as its original Microsoft counterpart. Description The TEXTAFTER function extracts all text that occurs after a specified delimiter or substring. It’s the perfect tool when you need to … Read more
The TEXTBEFORE function was officially introduced with Excel 2021, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013, 2016, 2019 and 2021 versions. It works exactly as its original Microsoft counterpart. Description The TEXTBEFORE function extracts all text that occurs before a specified delimiter or substring. It’s the perfect tool when you need to … Read more