If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sorting a single column
If I change the sort options in a single field to be separated by anything
such as a full stop or space and then go to sort that field I only get the option of using paragraphs and could not sort by the second field first. In other words if I have a first name and second name in one column. I cannot sort by second name. I can only sort by the first field first. eg Fred Bloggs Jo Smith Thanks |
#2
|
|||
|
|||
sorting a single column
"Phippsy" wrote:
If I change the sort options in a single field to be separated by anything such as a full stop or space and then go to sort that field I only get the option of using paragraphs and could not sort by the second field first. In other words if I have a first name and second name in one column. I cannot sort by second name. I can only sort by the first field first. eg Fred Bloggs Jo Smith Thanks Hi Phippsy, Sort once using paragraphs. That allows Word to analyze the table, and you should get "Word 1, Word2" as sorting options for another sort. Since that's quick, I usually do it that way. BTW, in Word2003 if I open the Options and explicitly enter a space in "Delimiter Other:", back in the sorting dialog I get the option to sort by word. Maybe it's something that was fixed in newer versions? Or maybe it only works if the table is not too complex... But the first method has always worked for me. Regards, Klaus |
#3
|
|||
|
|||
sorting a single column
I think I must be doing something wrong because I don't get that even when I
try in 2003. I am using a VERY simple table to practice on! "Klaus Linke" wrote: "Phippsy" wrote: If I change the sort options in a single field to be separated by anything such as a full stop or space and then go to sort that field I only get the option of using paragraphs and could not sort by the second field first. In other words if I have a first name and second name in one column. I cannot sort by second name. I can only sort by the first field first. eg Fred Bloggs Jo Smith Thanks Hi Phippsy, Sort once using paragraphs. That allows Word to analyze the table, and you should get "Word 1, Word2" as sorting options for another sort. Since that's quick, I usually do it that way. BTW, in Word2003 if I open the Options and explicitly enter a space in "Delimiter Other:", back in the sorting dialog I get the option to sort by word. Maybe it's something that was fixed in newer versions? Or maybe it only works if the table is not too complex... But the first method has always worked for me. Regards, Klaus |
#4
|
|||
|
|||
sorting a single column
I think I must be doing something wrong because I don't get that even
when I try in 2003. I am using a VERY simple table to practice on! You click on the down arrow where it currently says "with: Paragraphs", and you don't see "Field 1", "Field 2"? If the names aren't in a table, do the lines end in paragraph marks? Else, I'm out of ideas... You could mail me your sample to look for something funny, but I probably won't be able to get back to you before next Tuesday. Regards, Klaus |
#5
|
|||
|
|||
sorting a single column
They are in a table and it sounds so simple but no I don't see Field 1 etc. I
would love to send it to you - what is your address? Thanks Debbie "Klaus Linke" wrote: I think I must be doing something wrong because I don't get that even when I try in 2003. I am using a VERY simple table to practice on! You click on the down arrow where it currently says "with: Paragraphs", and you don't see "Field 1", "Field 2"? If the names aren't in a table, do the lines end in paragraph marks? Else, I'm out of ideas... You could mail me your sample to look for something funny, but I probably won't be able to get back to you before next Tuesday. Regards, Klaus |
#6
|
|||
|
|||
sorting a single column
|
#7
|
|||
|
|||
sorting a single column
Hi Debbie,
Seems to be caused by the table heading. If you cut the heading row temporarily before sorting, or add a second word to the table heading above the names, you can sort by second word. Never noticed that can be a problem... I guess Word should ignore the table headings when determining the sort fields! Regards, Klaus "Klaus Linke" wrote: "Phippsy" wrote: They are in a table and it sounds so simple but no I don't see Field 1 etc. I would love to send it to you - what is your address? Thanks Debbie Hi Debbie, You can see my mail addy if you click on my name. In case that doesn't work for some reason, either or :-) Klaus |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting Data in a column | BigAndy | General Discussion | 1 | September 13th, 2005 10:05 AM |
Running total w/2 columns - Excel | RagDyeR | Worksheet Functions | 2 | August 10th, 2005 04:28 PM |
Lookup Table Dilemma | Karen | Worksheet Functions | 2 | June 10th, 2005 08:22 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
How to Transpose a table to a single column | GB | Worksheet Functions | 1 | November 8th, 2003 05:34 PM |