How do I alphabetize a 6 page list I have made.
The list is all websites. They are uppercase and underlined.
Below each address is a username and password.
When I tried to "sort" the document, it got all seperated and split up. All the websites start with a different letter. I want to alphabetize this list. It is one column per page.
I don't know what to call it. Data sheet, spreadsheet, etc..I am not an office person, so I just call it a list.
Any direction on how to alphabetize this list will be appreciated.
Have a great holiday,
Fumbly210
[Solved] Alphabetizing lists as typed
[Solved] Alphabetizing lists as typed
Last edited by Fumbly210 on Wed Dec 01, 2010 2:09 am, edited 1 time in total.
Openoffice 3 on Windows 7
Re: alphabetizing lists as typed...
What application did you use to create the list, Writer or Calc?Fumbly210 wrote:How do I alphabetize a 6 page list I have made.
The list is all websites. They are uppercase and underlined.
Below each address is a username and password.
When I tried to "sort" the document, it got all seperated and split up. All the websites start with a different letter. I want to alphabetize this list. It is one column per page.
I don't know what to call it. Data sheet, spreadsheet, etc..I am not an office person, so I just call it a list.
Any direction on how to alphabetize this list will be appreciated.
Have a great holiday,
Fumbly210
OpenOffice.org v3.3, LibO v3.32 on Ubuntu 10.10 and Win7
Re: alphabetizing lists as typed...
Therabi. I'm not sure what you're talking about. On the splash page I clicked on document and took it from there.
Openoffice 3 on Windows 7
Re: alphabetizing lists as typed...
Therabi.
I just went back and worked with the installing of 3.2.
I had a choice of writer or calc...among others. I chose writer and opened it up.
I'll try to sort it now and see what happens.
I just went back and worked with the installing of 3.2.
I had a choice of writer or calc...among others. I chose writer and opened it up.
I'll try to sort it now and see what happens.
Openoffice 3 on Windows 7
Re: alphabetizing lists as typed...
Therabi,
No dice on the sorting. I clearly don't know what I'm doing.
No dice on the sorting. I clearly don't know what I'm doing.
Openoffice 3 on Windows 7
Re: alphabetizing lists as typed...
Does the page your working on look like a sheet of plain paper or like graph paper with lines running up/down and across?
OpenOffice.org v3.3, LibO v3.32 on Ubuntu 10.10 and Win7
Re: alphabetizing lists as typed
paper is like piece of plain white stationary. The column of addresses is margined fluch left. There are two spaces between each entry....I'll try to show you ..
DDDDD.DDD
uxxxxxxx - xxxxh
pxxxxxxx - xxxxxxx
FFFFFFFFFFFF.COM
usexxxxx - ddddd. dddd
pasxxxxx - jjjjm.jjjjj
and so on for 6 pages.
DDDDD.DDD
uxxxxxxx - xxxxh
pxxxxxxx - xxxxxxx
FFFFFFFFFFFF.COM
usexxxxx - ddddd. dddd
pasxxxxx - jjjjm.jjjjj
and so on for 6 pages.
Openoffice 3 on Windows 7
Re: alphabetizing lists as typed
You need to have each link + use + pass on one line, making 1 paragraph. Then highlight the full text and then sort. What is happening is that Write is seeing each line as a new paragraph and sorting everything. A simpler way would have been to do it in Calc with link in the first column, use in the second and pass in the third.Fumbly210 wrote:paper is like piece of plain white stationary. The column of addresses is margined fluch left. There are two spaces between each entry....I'll try to show you ..
DDDDD.DDD
uxxxxxxx - xxxxh
pxxxxxxx - xxxxxxx
FFFFFFFFFFFF.COM
usexxxxx - ddddd. dddd
pasxxxxx - jjjjm.jjjjj
and so on for 6 pages.
OpenOffice.org v3.3, LibO v3.32 on Ubuntu 10.10 and Win7
Re: alphabetizing lists as typed
There is a way to do it. Using a set of replace commands. Make a copy of your file and work with the copy.
Press Ctrl+F, then type ^$ in the Search for box and || in the Replace with box. Click More options and click Regular expressions. Click Replace all. That will remove all paragraph breaks. Now type || in the Search for box and \n in the Replace with box and click Replace all again. Now all entries are on their own line. Select all text (Ctrl+A), Tools - Sort - go for it.
If your problem has been solved, please edit the first post in this thread and add [Solved] to the title bar.
Press Ctrl+F, then type ^$ in the Search for box and || in the Replace with box. Click More options and click Regular expressions. Click Replace all. That will remove all paragraph breaks. Now type || in the Search for box and \n in the Replace with box and click Replace all again. Now all entries are on their own line. Select all text (Ctrl+A), Tools - Sort - go for it.
If your problem has been solved, please edit the first post in this thread and add [Solved] to the title bar.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum