Text-To-Column Function in Microsoft Excel

Instructor:  Jed Guinto
Course Dates: Open-ended
Enrollment Dates: Enroll Anytime
Who can Enroll: Anyone
Course Language: English
Price:  FREE

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
  • Concatenation
  • Multi-Parsing
  • Filter Clean Combination



Course Structure

  • Text-To-Column
    • Introduction
      • Don't forget to download the work file so you can follow along!
    • Fixed Width (Bonus Data Prep)
    • Fixed Width (Arrow Removal)
    • Text-to-Column and Multi-Parse
    • Concatenate
    • Filter Clean Combination (Bonus)
    • Thanks for Watching


Jed Guinto
Jed Guinto
Jed Guinto is the Co-Founder of Paperclip Learning. Currently pursuing his Ph.D. in Aerospace Engineering, he is also an avid educator with experience teaching primary students, high school students and undergraduate Aerospace, Civil and Mechanical Engineers. Over 44,000 students from over 170 countries have signed up for his courses.

This entry was posted in . Bookmark the permalink.