Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
My bank allows me to download transactions but only in .qif or .ofx formats (Quicken and MS Money). Any way to get into Excel or Open Offices Calc? The .qif format looks like this in Word (2 records shown) D01/02/2006 T-15.70 MPOS MERCHANDISE;COMPOOTER WARE #2173; ^ D01/02/2006 T-14.52 MPOS MERCHANDISE;CHEVRON 89002074; ^ I would like to see each line in separate filed - so I would have two records like D01/02/2006 T-15.70 MPOS MERCHANDISE;COMPOOTER WARE #2173; D01/02/2006 T-15.70 MPOS MERCHANDISE;CHEVRON 89002074; Since the 2nd filed is a number - any way I could strip out the 'T-' so I could do calculations? I don't have Perl or any scripting language on my XP home setup - any suggestions? Thanks, Tmuld. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to convert text into date format? | Excel Discussion (Misc queries) | |||
How to convert decimal numbers to time format | Excel Worksheet Functions | |||
document doesn't open unrecognizable format | Excel Discussion (Misc queries) | |||
Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
My document won't open, tells me file format is not valid | Excel Discussion (Misc queries) |