Excel: How To Split Data Single Columns Into Multiple in Microsoft Excel

In Excel (2016, 2013, 2010) , very simple few step you can do easily it. t’s possible to parse data from one column into two or multiple columns. For Example column A contains 2 or more like “Last Name, First Name”. Follow these steps to split the data from column A into a “Last Name” column and a “First Name” column. No cutting and pasting necessary! You can get Excel  all How To  info in MondalTech .

let’s go, here the Video of Split Data Single Columns Into Multiple , Open the Excel spreadsheet containing the data you want to split, then:

Step 1. Highlight the column that contains the combined data (e.g., Last Name, First Name) by clicking the letter directly above the column.

Step 2. Click the “Data” tab in the ribbon, then look in the “Data Tools” group and click “Text to Columns.” The “Convert Text to Columns Wizard” will appear.

Step 3. In step 1 of the wizard, choose “Delimited” > Click [Next].

Step 4. A delimiter is the symbol or space which separates the data you wish to split. For example, if your column reads “Jon, Cater” you would select “Comma” as your delimiter. Select the delimiter within your data.

Step 5. Check the box next to “Treat consecutive delimiters as one.”

Step 6. Click [Next].

Step 7. Under “Column data format,” choose “General.”

Step 8. Click the red arrow/spreadsheet icon at the far right of the “Destination” text box.

Step 9. Highlight the columns you wish to contain the split data by clicking the letters directly above the columns (you can choose columns from anywhere within the spreadsheet). Or, manually click and drag to select the sells you wish to contain the split data.

Step 10. Click the red arrow/spreadsheet icon once more to return to the wizard.

Step 11. Click [Finish].


Leave a Comment