Easy & Quick Way to Merge and Split Column/Row Data in Excel

 

Easy & Quick Way to Merge and Split Data in Excel

1. Select the column which contain your Text/Data which you want to split. (Without Including Header)

    

2. Select the Data Tab from the Tab menu

    

3. Select Text to Columns option

    

4. Choose “Delimited” option and Click Next

        

5. Choose Space if you want to split your text having Space (You can choose comma, semicolon as required) & Click on Next

        

6. Click on up arrow in Destination option then, choose location (absolute address) where you want your text to insert

        

7. Click Finish, now all done You have got your text in required columns.