![]() Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. If you have Kutools for Excel installed, you can use the Split Cells utility to quickly and easily split a single cell into multiple columns or rows based on a character, a word, or carriage return without the long and troublesome steps.įor example, here is a single cell with contents separated by a word “KTE”, now you need to split the cell based on the word into multiple cells. Now the single cell has been split into multiple rows. 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? ![]() How to split a cell into multiple rows or columns based on a character/a word/carriage return? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |