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.

Nguồn: https://synergytoday.org/

Xem thêm bài viết khác: https://synergytoday.org/tong-hop/

21 COMMENTS

  1. 🔥🔥🔥 WIN A SAMSUNG GALAXY A10 HERE : https://youtu.be/3vamWTYv3Mk

    CONTEST IS VALID TILL DECEMBER 22, 2019

  2. ❗ Subscribe To Our Main YouTube Channel

    https://www.youtube.com/user/howtechpc

  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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here