How to Split Cells in Excel (In Easy …
https://www.excel-easy.com/examples/split-cells.html
1. First, split the contents of one cell into multiple cells. 2. Select cell B1 and press CTRL + E (flash fill shortcut). 3. Select cell C1 and press CTRL + E. 4. Select cell D1 and press CTRL + E. Select the cell and press CTRL + E to use flash fill. Repeat for each adjacent cell that you want to split the data into. Alternatively, select the data and press ALT + A + E to use text to columns.
Select the cell and press CTRL + E to use flash fill.
Repeat for each adjacent cell that you want to split the data into.
Alternatively, select the data and press ALT + A + E to use text to columns.
DA: 49 PA: 47 MOZ Rank: 91