You give no examples but have you tried
Datatext to columns

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sandeep" wrote in message
...
i want to demerge the content cell a lot of data
into 2 or 3 steps