Then in the Paste Special dialog, check All in Paste section, and None in Operation section, and then check Transpose checkbox. Then select a blank cell, and right click to select Paste Special from the context menu. After splitting the data into multiple columns, select this column cells, and press Ctrl + C to copy them.Ģ.
Tip: If you want to split a cell based on a character into multiple rows, after finishing above steps, you need to go on below steps:ġ. Click Finish, you can see the single cell is split into multiple columns. 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?
EXCEL SPLIT CELLS BASED ON CHARACTER HOW TO
How to split a cell into multiple rows or columns based on a character/a word/carriage return?
0 kommentar(er)
