How to Split a Cell in Excel 2016

Công Nghệ

Don’t forget to check out our main channel for more free how-to videos!
Join us on Facebook

Our App

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.


Xem thêm bài viết khác:

24 thoughts on “How to Split a Cell in Excel 2016



  2. ❗ Subscribe To Our Main YouTube Channel

  3. Please, please, please create a tutorial on how to actually split a single cell WITHOUT putting data into 2 columns.

  4. Hi, thank you for the video and the fast way you explain things. I need to split an empty cell into two (it has not been merged and I don't want to shift any of the surrounding cells anywhere). How would I be able to do this? Thank you for your time.

  5. This is more like splitting words and distributing to the number of cells but it is not splitting a cell.

  6. Go slow. Every step should be explained as if you are teaching a novice. As a teacher don't assume the other person knows a lot. Your instructions are too fast for somebody who is learning how to do the splitting.

Leave a Reply

Your email address will not be published. Required fields are marked *