How Do I Split a Cell Into Multiple Cells?
There are several ways to split a cell into multiple cells, depending on the content of the cell you want to split.
Split a Cell With Convert Text to Columns
You need to determinate a pattern in order to split a cell. This pattern would be some delimiter like a comma, semicolon, or colon.
Split a Cell With Excel Functions
You can do the same thing using Excel functions. This approach is best if the cell only contains two parts you need to split. The benefit is using a function is much faster than the previous method.
Split Cells Using Flash Fill
Flash Fill in Excel is a very convenient feature which will magically figure out the delimiter based on an example you type in adjacent cells.
Split One Cell Across Multiple Adjacent Cells
If you’d like to make one cell span across several cells next to it, there is a simple trick to do this.
