Computer Hope

Other => Other => Topic started by: Broni on July 12, 2008, 09:43:49 PM

Title: Sort list alphabetically
Post by: Broni on July 12, 2008, 09:43:49 PM

I have a text file with a list of computer files.
What would be the best tool to use to sort them alphabetically?
Thanks.

Title: Re: Sort list alphabetically
Post by: Carbon Dudeoxide on July 12, 2008, 10:10:14 PM

What about Microsoft Excel?

You can paste the list to Excel and use Data --> Sort

(This is for M$ Office 2003)

Title: Re: Sort list alphabetically
Post by: Broni on July 12, 2008, 10:12:06 PM

I was thinking about Excel/Open Office Calc, but I thought, maybe it's some easier way.

Title: Re: Sort list alphabetically
Post by: Broni on July 12, 2008, 10:13:19 PM

Then, my final product must be some kind of text file.
I'm sorry, but all word processing stuff is little bit alien to me.

Title: Re: Sort list alphabetically
Post by: Carbon Dudeoxide on July 12, 2008, 10:16:12 PM

Can't you, once it's sorted, paste it back into the text file?

Title: Re: Sort list alphabetically
Post by: Broni on July 12, 2008, 10:17:36 PM

Can I? I simply don't know.

Title: Re: Sort list alphabetically
Post by: Carbon Dudeoxide on July 12, 2008, 10:20:01 PM

I can    :D

Do you need help with Sort or are you ok?

Title: Re: Sort list alphabetically
Post by: Broni on July 12, 2008, 10:23:45 PM

Let me try.

Title: Re: Sort list alphabetically
Post by: Broni on July 12, 2008, 10:29:21 PM

OK, using Open Office Calc
I have 4 words in column A. How do I sort them alphabetically?

Title: Re: Sort list alphabetically
Post by: Carbon Dudeoxide on July 12, 2008, 10:31:12 PM

I don't know about Calc but if the buttons are the same, Highlight the 4 words and go to Data --> Sort and sort it by Column A

Title: Re: Sort list alphabetically
Post by: Carbon Dudeoxide on July 12, 2008, 10:34:04 PM

(http://www.fileupyours.com/files/151662/1aa.JPG)

(http://www.fileupyours.com/files/151662/2aa.JPG)

(http://www.fileupyours.com/files/151662/3aa.JPG)

(http://www.fileupyours.com/files/151662/4aa.JPG)

Title: Re: Sort list alphabetically
Post by: Broni on July 12, 2008, 10:35:41 PM

Very good. I did it.
Now, how can I save it as text file? I can't see that option under File>Save As.

Title: Re: Sort list alphabetically
Post by: Carbon Dudeoxide on July 12, 2008, 10:36:56 PM

Highlight the names, CTRL + C, go to Notepad and CTRL + V

Title: Re: Sort list alphabetically
Post by: Broni on July 12, 2008, 10:39:18 PM

Wow!
That simple.
Thank you, my friend :)

Title: Re: Sort list alphabetically
Post by: Broni on July 12, 2008, 10:40:33 PM

One more question.
I can see 80 rows in column A. What do I do after 80th item?

Title: Re: Sort list alphabetically
Post by: Carbon Dudeoxide on July 12, 2008, 10:42:06 PM

Quote from: Broni on July 12, 2008, 10:39:18 PM

Wow!
That simple.
Thank you, my friend :)

LOL

Quote from: Broni on July 12, 2008, 10:40:33 PM

One more question.
I can see 80 rows in column A. What do I do after 80th item?

Can't you go down any further?
(http://www.fileupyours.com/files/151662/further.JPG)

Title: Re: Sort list alphabetically
Post by: Broni on July 12, 2008, 10:45:14 PM

Oh, yes. I thought 80th was the last row, but now I can see, the slider goes further.
Good going :)

Title: Re: Sort list alphabetically
Post by: Carbon Dudeoxide on July 12, 2008, 10:46:10 PM

I can't believe someone like you doesn't know Word Processing.  :o

Title: Re: Sort list alphabetically
Post by: Broni on July 12, 2008, 10:49:12 PM

Shhhhhhhhhhhhhhhhh.....LOL

Title: Re: Sort list alphabetically
Post by: Carbon Dudeoxide on July 12, 2008, 10:51:06 PM

Oh well, I will ponder this question all night now....
Good Night.

Title: Re: Sort list alphabetically
Post by: Broni on July 12, 2008, 10:52:49 PM

Going to the movies, pretty soon.
I appreciate your help :)