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?