Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
anne anne is offline
external usenet poster
 
Posts: 71
Default ABC order last names on list where last names are last

I have a list of 100 names I need to put in alphabetical order. I need the
list to be first then last name but in ABC order by last name.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Rae Drysdale Rae Drysdale is offline
external usenet poster
 
Posts: 507
Default ABC order last names on list where last names are last

Do the list in a 2-column table and sort it on surname (2nd column). Then
select the table and from the Table menu select Convert Table to Text. This
will give you a list with a tab character between the two names. Do a Search
and Replace the tab character from the Special list with a space (just type a
space in the replace box). Does this solve your problem?
--
Rae Drysdale


"Anne" wrote:

I have a list of 100 names I need to put in alphabetical order. I need the
list to be first then last name but in ABC order by last name.

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default ABC order last names on list where last names are last

If each name in the list has just two words (first name and last name), you
can select it and use Table | Sort to sort by Word 2. If some names have
more than one "first name," replace the space between them with a
nonbreaking space (Ctrl+Shift+Spacebar), and they will be treated as a
single word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Anne" wrote in message
...
I have a list of 100 names I need to put in alphabetical order. I need

the
list to be first then last name but in ABC order by last name.


  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Rae Drysdale Rae Drysdale is offline
external usenet poster
 
Posts: 507
Default ABC order last names on list where last names are last

That's cool Suzanne.
--
Rae Drysdale


"Suzanne S. Barnhill" wrote:

If each name in the list has just two words (first name and last name), you
can select it and use Table | Sort to sort by Word 2. If some names have
more than one "first name," replace the space between them with a
nonbreaking space (Ctrl+Shift+Spacebar), and they will be treated as a
single word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Anne" wrote in message
...
I have a list of 100 names I need to put in alphabetical order. I need

the
list to be first then last name but in ABC order by last name.



  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default ABC order last names on list where last names are last

Sometimes you have to monkey with the sort Options (changing the separator
character to space, for example) to force Word to display Word 1 and Word 2.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Rae Drysdale" wrote in message
...
That's cool Suzanne.
--
Rae Drysdale


"Suzanne S. Barnhill" wrote:

If each name in the list has just two words (first name and last name),

you
can select it and use Table | Sort to sort by Word 2. If some names have
more than one "first name," replace the space between them with a
nonbreaking space (Ctrl+Shift+Spacebar), and they will be treated as a
single word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Anne" wrote in message
...
I have a list of 100 names I need to put in alphabetical order. I

need
the
list to be first then last name but in ABC order by last name.




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
order of file names Order of file names Microsoft Word Help 1 November 22nd 06 12:02 AM
How do I chart names in aphabetical order? Simple Question Tables 1 July 15th 06 07:46 PM
how do I view WORD files names in alphabetical order karen_a Microsoft Word Help 3 October 21st 05 08:56 AM
How do you put the names in alphabetical order? lele Microsoft Word Help 1 September 1st 05 06:28 PM
I have a list of names/address how do I sort in alaphbetical order missy_little Microsoft Word Help 0 June 9th 05 12:08 PM


All times are GMT +1. The time now is 06:56 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"