Word has a sort function that will sort text files. I think many word processors do also. The easiest thing to do would be to put it all on the same line and then sort. Then you need to beak it apart for the rest of the sort. Excel will learn a macro to do this of you can show it what you want. Else, you can write a macro to do so. From: Patrick <paw@wirelessbeehive.com> To: Utah Astronomy <utah-astronomy@mailman.xmission.com> Sent: Tuesday, May 8, 2012 3:43 PM Subject: Re: [Utah-astronomy] Excel challenge Hi, The original is a text file. I'm converting it to Excel so I can use Excel's sort function since I don't think text files can be sorted. I'll post a complete original file when I get home this evening for folks to play with. Thanks to all for their help. patrick On 08 May 2012, at 14:12 , Chrismo wrote:
i guess i'm not understanding how the original data is formatted. is this stuff: SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
not in a spreadsheet to start off with?
_______________________________________________ Utah-Astronomy mailing list http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Send messages to the list to Utah-Astronomy@mailman.xmission.com The Utah-Astronomy mailing list is not affiliated with any astronomy club. To unsubscribe go to: http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Then enter your email address in the space provided and click on "Unsubscribe or edit options".