Split a cell - Microsoft Support
https://support.microsoft.com/en-us/office/split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23
To split the content from one cell into two or more cells in Excel, you can use the Text to Columns feature12: Select the cell or cells whose contents you want to split. Go to Data > Data Tools > Text to Columns. Select the delimiter (e.g., comma, space) to define the places where you want to split the cell content, and then select Apply. Select the cell or cells whose contents you want to split. ... Go to Data > Data Tools > Text to Columns. ... Step 1) Select the cell content to be split into multiple cells. Step 2) Go to the Data tab > Data tools > Text to Column. ...
Select the cell or cells whose contents you want to split.
Go to Data > Data Tools > Text to Columns.
Select the delimiter (e.g., comma, space) to define the places where you want to split the cell content, and then select Apply.
Select the cell or cells whose contents you want to split. ...
Go to Data > Data Tools > Text to Columns. ...
Step 1) Select the cell content to be split into multiple cells.
Step 2) Go to the Data tab > Data tools > Text to Column. ...
DA: 2 PA: 37 MOZ Rank: 96