Splitting Data - Text to Columns in Microsoft Excel

Published on: April 10, 2015

Welcome to the 11th Excel Tutorial where I show you how to split cell data. Tutorial 10 showed you how to combine them, or concatenate data, today's tutorial covers the opposite. What do you do when you have a lot of data in one cell but you need to separate them?

This tutorial covers the basics of the text to columns tool in excel. Learn how to easily split cell data in this tutorial.

Remember to checkout the Resources section below for associated downloadable content, JSFiddle links, and other resources. Watch the video and follow along!


Download the associated Excel Spreadsheet here: Download