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. 60-day money back guarantee.How to convert one cell to multiple cells/rows in Excel? Easy deploying in your enterprise or organization.
Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.
#Convert text to rows in excel password#
Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by See screenshots:īut in Excel, you cannot quickly convert a single row data to a range with multiple columns and rows except manually copying and pasting, now I introduce a handy method for you.Ĭonvert a single row to multiple columns and rows with Transform Range Kutools for Excel, with more thanģ00 handy functions, makes your jobs more easier. Note: If you want to convert the single cell values to multiple rows, you just need to convert it to multiple columns first, then select the column values and press Ctrl + C to copy them, then select a cell and right click to select Paste Special > Transpose. Click Finish, then the single cell has been converted to multiple columns, and then resize the columns. In the popping dialog, check Delimited option firstly, click Next to go the step 2 of the dialog, and check Space option under Delimiters section. Select the cell you need to convert, and click Data > Text to columns.
In Excel, you only can convert a single cell to multiple columns or rows.ġ. Here I introduce two methods may help you quickly solve this task.Ĭonvert a cell row to multiple columns or rows with Text to Columns and Paste Transpose functionsĬonvert a single row to multiple columns and rows with Transform Range Suppose you have a row with a large data, and now you want to convert this single row to a range with multiple columns and rows as below screenshot shown, how can you solve it in Excel?
#Convert text to rows in excel how to#
How to convert a single row to multiple columns and rows in Excel?