![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
I am trying to download the OLC info for our club in Excel format. This I
can do successfully. However, while the file is named ".XLS" it appears to be a delimited text file. When I load it into Excel, for every flight, I get 3 lines in the Excel Spreadsheet. The first line goes to the end of the given name, the next is the surname, and the third is the rest of the record. While I can fix all of this by hand, I'd rather not. Looking at the file with Notepad, it appears the culprit are 2 CR embedded in the name field, with tabs between the items in the name field. Anybody have a way of easily loading the file provide by the OLC into Excel? Thanks, John |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Logbook update | [email protected] | Soaring | 0 | September 8th 07 02:49 PM |
Excel Flightlog | Sally W | Soaring | 2 | January 7th 07 11:53 PM |
Excel formula for logbook | Wizard of Draws | Instrument Flight Rules | 11 | August 30th 04 12:55 AM |
Excel worksheet and chart | Paul | Owning | 2 | November 3rd 03 09:42 PM |
Excel Worksheet and Chart | Paul | Piloting | 9 | October 30th 03 09:52 PM |