Thanks very much Pike for your reply.
I have tried your last code but sorry it didn't worked!
Well the original file is PDF and I have converted into text. The data of text file is too large so adding delimiters or applying tab will take too long time!
But one common thing is that there are exactly 26 columns in each entry( you can see the excel file i have attached earlier)
Thanks
Rocky
Bookmarks