About the Course
This is one of the funniest functions in Excel. Its funny because I see people time and time again, going into individual cells, cutting out a part and pasting it into another cell. They repeat the same thing over and over again for hundreds of line items. If only they knew that this function can do all of that in a few clicks. If you’re one of my enemies, then navigate away from this page. If you’re one of my beloved students, then continue reading!
Text-To-Columns is a very powerful tool. Especially in cases where you processing data from another source, say the internet and other software packages. It allows us to quickly divide our data such that we can control it much easier.
This is designed for users that handle large tables of data
This is a relative short course with just over 5 videos with a total time of just over 10 minutes.
This is for advanced users.
- Fixed Width Delimitting
- Filter Clean Combination
Don't forget to download the work file so you can follow along!
- Fixed Width (Bonus Data Prep)00:00:00
- Fixed Width (Arrow Removal)00:00:00
- Text-to-Column and Multi-Parse00:00:00
- Filter Clean Combination (Bonus)00:00:00
- Thanks for Watching00:00:00