ROBOT.LK

I have an Excel File. I want to make it like the attachment 2 Please help me for that. The Thing i want to do is split the text. Tell me the way I will do.

Thanks

I want to change this as attachment 2

I don't about automating it, but you will be able to use cut and paste with inserting new rows in between.

I think you can do that using AutoIT. It very usefull to automation works.
simply download it from http://www.autoitscript.com/ and see it's help file. i think u will can do, if u have any knowladge in programming.

[ Post made via Mobile Device ]

I fixed that

anyway thanks for replies.