Excel Tutorial - How to use the Text to Columns Tool to Parse and Clean your Data

Covers how you can use the text to column tool.

This is a very useful tool, here are some use cases:

- Maybe you want to pull out someones company name through their email address
- When you an entire address in one column, you can use this tool to get the proper info (street, city, state, zip, country) into seperate columns.

- Delimited: breaking up columns based on characters such as commas, tabs, or spaces.
- Fixed Width: select the exact location on all the columns that you want the split/parse to execute.

Video Made Using: Microsoft Excel 2019

-~-~~-~~~-~~-~-
Please watch: "How to Show or Hide the Side bar In Tableau"
-~-~~-~~~-~~-~-