*** Urgent help. *** Take Data from text file and output in text file

[kakhils]

Take 102201631000-102201633999-234245 from text file and take right formula from first two numbers =right(text1,6) & right(text2,6). i.e. 631000 & 633999 then i need to place them in text like.

102201631000 234245
102201631001 234245
102201631002 234245
102201631003 234245
till
102201633999 234245

in .txt output keeping text as fixed.

 

[kakhils]

Wow¡¡ it worked... Thank u very much.. For your time and help...

 

[mumps]

Glad it worked out.

 

[kakhils]

It worked .. But It don't handle large data.. It stops working..

 

[mumps]

I mentioned to you in a previous post that the maximum number of rows that Excel 2007 and later versions can handle is 1,048,576. If you have more than the maximum number of rows, it won't work. The only thing you can do is split the data into two or more separate sheets or even separate workbooks so that you don't exceed 1,048,576 rows on any one sheet. Do you have more than the maximum rows in one sheet?

 

[kakhils]

Yes i have that much of data .. that i have to work at least 20 times with same workbook and then save one by one in text file.

 

[mumps]

Unfortunately, Excel does have some limitations but you have a huge amount of data!!!!!!

 

[kakhils]

Any ways.. But your code worked for me... Kudos... Thanks for the support..

 

[mumps]

Glad to help.