Excel’s Hidden Ctrl + J Trick (Almost Nobody Knows This)
Automate Excel Here - AI Function in Excel
In this tutorial, I'll show you how to use the hidden shortcut Ctrl+J to make it much easier when cleaning up messy data in Excel or extracting text from cells.
In addition, I'll show you 5 really great tips for text extraction and manipulation in Excel that include advanced formulas and functions, flash-fill, the special CHAR(10) character, and a custom AI function that will extract what you want from your spreadsheets.
If you'd like to learn more about automating Excel, check our Excel Automation Courses.
I hope you enjoy the video! :)
Don
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)