Hi Leith,

Thanks for your help in mr excels post.

That is same post, there I was looking from text data into Seperate Columns in excel.
Now I brought the answer in excel by googling, it will be easy in excel to do testing .

Please assist in seperating data from excels single columns to multiple Columns as per data. Thanks.
It will help me in understanding loop perfectly. Thanks

Regards,
mg