A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

sorting a single column



 
 
Thread Tools Display Modes
  #1  
Old September 29th, 2005, 09:31 PM
Phippsy
external usenet poster
 
Posts: n/a
Default 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  
Old September 30th, 2005, 03:12 PM
Klaus Linke
external usenet poster
 
Posts: n/a
Default 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  
Old September 30th, 2005, 04:51 PM
Phippsy
external usenet poster
 
Posts: n/a
Default 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  
Old September 30th, 2005, 06:01 PM
Klaus Linke
external usenet poster
 
Posts: n/a
Default 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  
Old September 30th, 2005, 06:15 PM
Phippsy
external usenet poster
 
Posts: n/a
Default 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  
Old September 30th, 2005, 06:31 PM
Klaus Linke
external usenet poster
 
Posts: n/a
Default sorting a single column

"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



  #7  
Old October 4th, 2005, 12:59 PM
Klaus Linke
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.