one cell to different rows

[itsgagandeep]

HI,

Plz help me in this

i got data in one cell
1,2,3,4,5

i want to change this data in different rows like ,
1
2
3
4
5


it should be inserted in the new row, not overwrite the current data .

 

[rahulbassi]

Its working....thanks a lot...