Split unmerged cell using a formula. In Excel, you can also split an unmerged cell using the Text to Columns option. Select the cells you want to split into two cells. On the Data tab, click the Text to Columns option. In the Convert Text to Columns Wizard, if you want to split the text in the cells based on a comma, space, or another character, select the Delimited option. 007 - Excel: Split one data column into multiples Recorded by Jerzy / George Jura for UW-Whitewater (USA) iCIT more at tinyurl.com/learnoffice.

How to convert one cell to multiple cells/rows in Excel? Sometimes, it is difficult to view all the data if there are lots of data in a cell in 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. In Excel, you can get it done through below methods. Quickly Split one cell into columns or rows based on delimiter In Excel, to split a cell into columns is tedious with the Wizard step by step.

This option is enabled by default. Warn me when emergency services location cannot be determined Select this option to receive an alert when your location cannot be determined in the event of an emergency. This option is enabled by default. The Audio/Video Preferences Menu The Audio/Video Preferences provide three (3) options that you can configure. Skype for business mac configuration information.

But with Kutools for Excel's 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. Convert one cell to multiple cells/rows with Text to Column and Paste Special 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: 5. 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. See screenshot: If you are using Microsoft Excel 2007, click the Home > Paste > Transpose to paste the split data. You can see the result as shown: Convert one cell to multiple cells/rows with VBA If you think the above method is a little tedious, you can use a VBA to get it done.

Hold ALT button and press F11 on the keyboard to open a Microsoft Visual Basic for Application window. Click Insert > Module, and copy the VBA into the module. VBA: Convert one cell to multiple rows Sub TransposeRange() 'Updateby20140312 Dim rng As Range Dim InputRng As Range, OutRng As Range xTitleId = 'KutoolsforExcel' Set InputRng = Application.Selection.Range('A1') Set InputRng = Application.InputBox('Range(single cell):', xTitleId, InputRng.Address, Type:=8) Set OutRng = Application.InputBox('Out put to (single cell):', xTitleId, Type:=8) Arr = VBA.Split(InputRng.Range('A1').Value, ',') OutRng.Resize(UBound(Arr) - LBound(Arr) + 1).Value = Application.Transpose(Arr) End Sub 3.

Click Run to run the VBA code, and a KutoolsforExcel dialog pops up for you to select a single cell you want to convert its data. See screenshot: 4. Click OK, and in another popup dialog select a cell to output the result. See screenshot: You can see the result: Tip: In the above VBA code, you can change the separator ',' you want to separate the data. Convert one cell to multiple columns/rows with Kutools for Excel If you have Kutools for Excel -- a handy tool installed, you can use its Split Cells fuction to quickly split a single cell to multiple columns or rows based on a delimiter. With more than 200 handy functions, makes your jobs more easier. After installing Kutools for Excel, please do as below: 1.