Text to Columns Excel: How to Split Data

In this lesson, we review how to split data (in one column) into multiple columns using the Text to Columns feature in Excel, as well as how to troubleshoot this Excel feature.

👉 Check out my courses to help you master Excel in a weekend: https://www.ericandrewsstartups.com/courses

🚀 If you want to master the finance skills & frameworks to successfully scale technology startups, secure your spot in my "Finance for Startups" program, today: https://www.ericandrewsstartups.com/financeforstartups

Communities:
💼 Linkedin: https://www.linkedin.com/in/eric-andrews-1624b656/
☑️ Twitter/X: https://twitter.com/eric__andrews
🌟 Instagram: https://www.instagram.com/ericandrews_startups/
🔥 Discord: https://bit.ly/discord_eric
💻 Newsletter: https://bit.ly/joinericnewsletter
🎥 Clips: https://www.youtube.com/channel/UCbM6zM3al9jZSyoRyJWQL-Q
____________________________________________

Learning how to use the Text to Columns feature comes in handy very often in Excel.

Quite frequently we receive data that is poorly organized, and jumped together in one column.

A great example is the classic "First Name, Last Name". This type of data is much more useful if we can separate the names so that we have the first name in one column, and last name in the other.

This is when we use text to columns function. We can split the data at the comma, a space, or any character that we choose.

The text to columns feature allows us to do this to an entire column in one move (rather than manually doing it cell-by-cell).

Now you should feel confident splitting Excel data with text to columns!

► Subscribe for more finance videos: https://bit.ly/EricAndrewsSubscribe

Видео Text to Columns Excel: How to Split Data канала Eric Andrews