If you think the above method is a little tedious, you can use a VBA to get it done.ġ. Click for full-featuredģ00 handy Excel add-ins, free to try with no limitation in But with Kutools for Excel's Split Cells utility, you can: 1,convert one cell into columns or rows based on delimiter 2,convert string into text and number 3,convert string based on specific width, with clicks. In Excel, to split a cell into columns is tedious with the Wizard step by step. Quickly Split one cell into columns or rows based on delimiter If you are using Microsoft Excel 2007, click the Home > Paste > Transpose to paste the split data. Select a blank cell you want and right click to select Transpose(T), then you can see the data has been converted into multiple rows. And now select these cells and right click to click Copy from the context menu to copy them. Then you can see the cell data has been split into multiple columns. Check Comma check box only in the dialog, and click Finish. In the pop-up dialog, check Delimited check box, and click Next. Select the cell you want to convert its data, and click Data > Text to Column, see screenshot:Ģ. In Excel, you can get it done through below methods.Ĭonvert one cell to multiple cells/rows with Text to Column and Paste Special in ExcelĬonvert one cell to multiple cells/rows with VBAĬonvert one cell to multiple columns/rows with Kutools for Excelġ. In this case, converting all the data in this cell to multiple cells or rows may make it much easier and clearer to view long content as shown as below. Sometimes, it is difficult to view all the data if there are lots of data in a cell in Excel. How to convert one cell to multiple cells/rows in Excel?
0 kommentar(er)
