You're welcome. It occurs to me that I never explained how I imported the file. Here's how you do that in Excel 2003: On the top menu bar, click "Data". In the drop down box that opens click "Import External Data". In the axillary dialog box, click "Import Data". A browsing box opens. Browse to the file and double click on the file or click on it then click Open. This opens a dialogue box. Select the radio button "Delimited". Click Next> In the Delimiters section of the box that opens, the "Tab" check box is checked by default. Additionally put a check in "Comma" (it looked like most of the data was separated by commas to me. There are some other choices if it isn't comma delimited). Click Next>. Click Finish. On the last sheet, select the appropriate radio button. I have always started this from the worksheet on to which I wanted to import the text file. Make sure the cell in the selection box is the one in which you want the data to start. Click OK The text file imports, in the same format as was on the spreadsheet I sent. From here you can copy this imported data to a different worksheet and Sort it as per the instructions I sent. On 5/9/2012 3:06 AM, Patrick Wiggins wrote:
Hi Bill,
You got it! Huzzah!!!
I had to remove columns D& E and then save it as a format called "Windows Comma Separated (.csv)"
No idea what that format is but the program accepted it.
Just another example of the huge amount of knowledge and willingness to help found here on Utah-Astronomy.
Thanks!
On 08 May 2012, at 22:13, William Lockman wrote:
It wasn't that hard either. I went ahead and sorted it for Patrick, then sent him the Excel file. It was a little tedious, but it wasn't that long of file.
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".