Go on click Next > to the Step 3 of wizard, and click to select a cell to put the split result. Click Next > button to go to Step 2 of the wizard, check Semicolon checkbox only. Then in the Step 1 of the wizard, check Delimited option, see screenshot:ģ.
Select the cell you want to split into multiple columns, and then click Data > Text to Columns. In Excel, to use the Text to Column function is a good way to split a single cell.ġ. Split a cell into multiple columns or rows with Kutools for Excel Split a cell into multiple columns or rows with Text to Column function
Supposing you have a single cell which contains multiple contents separated by a specific character, for instance, semicolon, and then you want to split this long cell into multiple rows or columns based on the semicolon, in this case, do you have any quick ways to solve it in Excel? How to split a cell into multiple rows or columns based on a character/a word/carriage return?
0 kommentar(er)
