Variable length records

[jackmanjls]

I have records from a checking acct, for several yrs, that I want to put in excel. The records are in a text file. The records all have different length, for example:

35 22 MAR CVSPHARMACY #3274 Q03ST JAMES CITYFL $13.28
40 23 FEB PUBLIX #1007CAPE CORALFL $6.78

The constant between all records is field1=index, field2=day, field3=month and the last field=dollar amount.

When I insert the text file, into xl, how do I have the last field for all records line up in the same column so that they can be summed?

 

[Somendra Misra]

Hi jackmanjls,

See the attached file. I m not sure whether it will fit your exact need. What I felt that after importing the text file you want to sum all the values.

1. Imported the file on Import Sheet.
2. Pulled the last values on Dollar Sheet.

Now you can do any function on these values.

Regards,