Write Excel Formulas with Built-In AI (Not ChatGPT)
This video shows how Microsoft has built AI into Excel, so that it can reverse engineer a formula based on provided sample data. This does NOT require leaving Excel to use a third-party AI platform such as ChatGPT. We cover:
Extracting text based on delimiter
Extracting text based on a fixed width
Combine multiple columns
Reversing values in a single column
Operating on numbers with multiplication
Learn more about this feature called Formula by Example at this Microsoft link:
https://techcommunity.microsoft.com/t...
Chapters:
00:00 - Introduction
00:32 - Delimiter
02:01 - Fixed
02:34 - Combine
03:14 - Reverse
03:45 - Extended
Excel How To Combine Multiple Tables with VSTACK • Excel How To Combine Multiple Tables ...
Learn Excel the FAST way, find out how here 👉 https://www.excel-university.com/yt
Check out Excel PivotTables for Beginners (2023) • Excel PivotTables for Beginners (2025)
Subscribe here 👉 / @excelu
and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
Watch VLOOKUP Hacks Playlist here • Vlookup Hacks: Hack #1 Sort Order
