Good day,
Let's make a custom search implementation in Excel that does NOT use VBA or Macros!
This allows you to search multiple sheets at once and view all results on a single worksheet.
Excel AI for Fixing Macros
Our automated tool for fixing and updating macros in Excel - this was built for complete novices to use!
We're adding more features now that the mvp has been completed - please reply to this email and let me know what else you'd like us to add to it!
(Thank you very much to those early beta testers who helped us get this finished!!!)
Stop Using Ctrl+F in Excel - Do This Instead
Can’t see the thumbnail? Click here to watch on YouTube
Last Week's Tutorial: Is VBA Dead? Or More Important than Ever?
Funny Work-Humor Clip
A little office humor from us to start the week, courtesy of YouTube Shorts.
[Tiny Tip] Extract Only Numbers From Text
If you have messy text like invoice numbers, order IDs, or mixed codes, you can pull out just the numbers with one formula and no helper columns.
The Formula
=TEXTJOIN("",TRUE, |
Tip: click into the box and copy the formula.
Example
If cell A1 contains:
Invoice: 98AB76C |
the formula returns:
9876 |
How It Works
Breaks the text into individual characters.
Checks each character to see if it is a number.
Keeps only the numeric characters.
Joins them back together into one result.
Notes
If you use an older version of Excel, this formula may not work.
Excel AI for Fixing Macros
Courses
Cheers and see you next week!
Don