Useful if someone sends you poorly formatted data
How to Split a Cell in Excel 2016
When you work with data in Excel that you've imported from other sources, you sometimes have to work with data that isn't in the format you want. This is especially true for comma-delimited text that ends up in separate cells.
The only way to deal with that data is to split a cell in Excel. There are several ways to do this, depending on the format of the data.
In this article, you'll learn how to split a cell, how to expand it to an entire column, and when to choose which option.
