How To Convert One Cell To Multiple Cells/Rows In Excel?

1. Select the cell you want to convert its data, and click Data > Text to Column, see screenshot:

 

2. In the pop-up dialog, check Delimited check box, and click Next. See screenshot:

 

3. Check Comma check box only in the dialog, and click Finish. See screenshot:

 

4. Then you can see the cell data has been split into multiple columns. And now select these cells and right click to click Copy from the context menu to copy them. See screenshot: