Où Puis-Je Acheter Booste Ton...
Gaming3 mins ago
Sorting alphabetically
7 Answers
Help wanted please. I have been given lists of names etc and need to make these lists alphabetical. So far, I haven't managed to "sort" them with any of the usual TextPad or NotePad or OpenOffice. (I don't have "Word") I'm sure I am being my usual dense self but can somebody out there point me in the right direction please!
Answers
1 to 7 of 7
Best Answer
No best answer has yet been selected by alzheimer. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
Try here with Calc:- (no Writer yet):-
http://openoffice.blogs.com/openoffice/2005/11/calc_quickies.html
Maybe this, using a database for the list (probably better anyway) and then doing a mail-merge?:-
http://openoffice.blogs.com/openoffice/2006/01/what_im_learnin.html
Save them in a text file in a folder
Click Start/Programs/Accessories/Command Prompt
At the prompt type:
CD "\The full path to the folder"
hit <enter>
at the prompt type:
Sort<name of file> sorted.txt
Type:
exit and hit <enter>
Open the file "Sorted.txt"
This assumes that you have typed them in the form Surname Forenames
Click Start/Programs/Accessories/Command Prompt
At the prompt type:
CD "\The full path to the folder"
hit <enter>
at the prompt type:
Sort<name of file> sorted.txt
Type:
exit and hit <enter>
Open the file "Sorted.txt"
This assumes that you have typed them in the form Surname Forenames
Hi,
I'm assuming that your text looks something like this: just one line, then carriage return, and so on.
John Majors
Billy Bob
Caren Rand
To sort them, select all the lines to sort, then choose Tools > Sort. I'm not sure why Sort would be grayed out. Maybe copy and paste all the data into a new document and see if it's still grayed out.
In the window that appears, you can just leave it with Key 1 and Column 1 marked. Then click OK.
That will sort the data by the first letter on the line; in this example the first name.
I'm going to blog more thoroughly on this later in the week at http://openoffice.blogs.com -- I'll cover sorting by first and last name and other stuff.
HTH,
Solveig
I'm assuming that your text looks something like this: just one line, then carriage return, and so on.
John Majors
Billy Bob
Caren Rand
To sort them, select all the lines to sort, then choose Tools > Sort. I'm not sure why Sort would be grayed out. Maybe copy and paste all the data into a new document and see if it's still grayed out.
In the window that appears, you can just leave it with Key 1 and Column 1 marked. Then click OK.
That will sort the data by the first letter on the line; in this example the first name.
I'm going to blog more thoroughly on this later in the week at http://openoffice.blogs.com -- I'll cover sorting by first and last name and other stuff.
HTH,
Solveig
'Evening everybody...it took me a while to try out the various suggestions - for which many thanks indeed. I seem to have started something! You will all be relieved to know that I have cracked it...and it was your idea, solveig, to start a new document that did it. The "sort" was no longer grayed out and I was in business. The idea of sorting about 100 names and email addresses was daunting without help and I will be interested to read your blog on the subject . You learn something new every day - even as an OAP!! Thanks again all.
1 to 7 of 7
