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

DESCRIPTION
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. 

TARGET AUDIENCE
This is designed for users that handle large tables of data

STRUCTURE
This is a relative short course with just over 5 videos with a total time of just over 10 minutes. 

DIFFICULTY
This is for advanced users.

COURSE OUTCOMES

  • Fixed Width Delimitting
  • Concatenation
  • Multi-Parsing
  • Filter Clean Combination

 

 

Course Structure

  • Text-To-Column
    • Introduction
      00:00:00
      • 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-Parse
      00:00:00
    • Concatenate
      00:00:00
    • Filter Clean Combination (Bonus)
      00:00:00
    • Thanks for Watching
      00:00:00

Instructors

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.