Microsoft Office 2007

[Nipuna]

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

Sheet2 Edited.xlsx

(30.05 KiB) Downloaded 544 times

attachment 2.xls

(99 KiB) Downloaded 386 times

[Herath]

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

[Rksk]

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 ]

[Nipuna]

I fixed that

anyway thanks for replies.