Microsoft Excel - unmerge the cells without lossing dat

hi,

i hve some data in excel sheet like

1	Abc	Apple	Mango	152
2	xyz			1563

and i want this above data like

1	usha	Apple	Mango	152
2	deepak	Apple	Mango	1563

thanks

anu

when you merged the cells, you lost the original data.  You can't just magically get it back.  Now, if simply want to copy the values, you can use the Excel Macro Recorder to manually perform the task once and look at the code the macro recorder generated for you and tweak it as needed.