Rohit Garg
07-12-2010, 12:00 AM
I have one excel sheet in which the '~' separated data needs to be displayed in the different cells
testdataseparate~this~to~different~rowstestsampleinputdata~to~be~seperatedt emp
Output should be:
testdataseparatetesttestdatathistesttestdatatotesttestdatadifferenttesttest datarowstestsampleinputdatatempsampleinputtotempsampleinputbetempsampleinpu tseperatedtemp
Data of 4th column is seperated in different cells. A new row is added for each string and all other cell data is copied as is in the new rows. Can any one tell me how to do this?
testdataseparate~this~to~different~rowstestsampleinputdata~to~be~seperatedt emp
Output should be:
testdataseparatetesttestdatathistesttestdatatotesttestdatadifferenttesttest datarowstestsampleinputdatatempsampleinputtotempsampleinputbetempsampleinpu tseperatedtemp
Data of 4th column is seperated in different cells. A new row is added for each string and all other cell data is copied as is in the new rows. Can any one tell me how to do this?