TXT to XLS

[gsgurdeep]

I have two log files of notepad. Data in file is seprated by ";".The name of product is same in both files. But with name one file contains PRICE & Other one contains QUANTITY.

Now i wants to genrate a MS EXCEL file that contains Product Name, Product Quantity ,Product Price in row colums format according both log files. Tell me any solution that automate my this work.

[sudkum]

I dont know exactly about previous verstion of office

but in office 2007

in DATA tab use text to coloumns to get the solution

use delimeter as ' ; '

[harshadd]

Hey man
if file is allready "," comma delimited just rename it as .csv and directly open it in MS Excel.

[gsgurdeep]

Hey man
if file is allready "," comma delimited just rename it as .csv and directly open it in MS Excel.

Thanks 4 Attention.Sorry Friend!
This idea is worked only one log file. But final data is generated by using two or more files.

So think again.

[harshadd]

can u paste some data here? or send me first 10 lines of data as attached text file?

[gsgurdeep]

First file contain

a,200 Rs.;b,500 Rs.;c,250 Rs.;a,200 Rs.;b,500 Rs.;c,250 Rs.

&

second file contain

a,35;b,50;c,150;a,35;b,50;c,150;a,35;b,50;c,150;a, 35;b,50;c,150;


This only for sample..........
use this for solution