Don’t forget to check out our main channel for more free how-to videos!
Join us on Facebook
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: https://synergytoday.org/tong-hop/