>I'm trying to turn it into a spreadsheet, for easier use, but the
>>blank lines are playing hell with function - not to mention the line
>>count and last few descriptive fields.
>>
>>RL
>
>I've been an Excel user for many years, yet I'm still a
>"stumbler/bumbler" :-(
>
>A mail pamphlet crossed my desk today offering a 2-day seminar in
>Excel, in nearby Tempe, for $128. I think I'll do it.
>
The newsgroup got it second try. Had to select all data on the worksheet, then specify the column to sort by separately.
This dumped the blank lines without loosing row consistency. The 12000 lines of the first worksheet are now closer to 6500.
RL