How to Split a Cell in Excel 2016

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:




  2. Go Fuck your self mate, did not show how to split a cell

  3. ahaha
    that's so fucked up :)))

    I've been trying to do this since awhile now and no tutorial shows this..

  4. Thanks for the great (and brief) video. Just what I needed!

  5. Why you sound like sexsirexsi

  6. WTF! Nothing about splitting cells!

  7. ❗ Subscribe To Our Main YouTube Channel

  8. Wrong procedure for "split a cell".  You split the content of a cell.  Big difference.

  9. This is exactly what I wanted lol. what the fuck was everyone else trying to do?

  10. You didn't split the cell, you split existing data between existing cells using the spaces.

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

  12. perfect! exactly what I needed and well explained

  13. 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.

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

  15. YOU DID NOT SPLIT ONE CELL. this is annoying click bait

Leave a Reply

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