Don’t forget to check out our main channel https://www.youtube.com/c/HowTech for more free how-to videos!
Join us on Facebook
http://www.Facebook.com/howtechtv
Our App
http://bit.ly/how-tech

In this tutorial, we’re going to show you how to split a cell in Excel 2016.

Firstly, if the cell is a merged cell, simply click the Merge & Center button to unmerge it or go under the drop-down and click Unmerge Cells.

If it is a singular cell with multiple words or something that can be parsed easily, go under the Data tab and click Text to Columns. The default values will work for our example, click Finish. Each word in the cell will be spread across one per column.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.