PC Review


Reply
Thread Tools Rate Thread

Alphabetize a Numbered List

 
 
fjrlem
Guest
Posts: n/a
 
      2nd Feb 2009
I have a list that is in numerical order. I need the list in alphabetical
order however I need the corresponding numbers to stay with the words. This
would make my numbers out of order. The list is numbered automaticly.
 
Reply With Quote
 
 
 
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      2nd Feb 2009
You could convert the numbers to text before sorting, but I fear Sort would
then still sort on the numbers. What you might try is this:

1. Convert the numbers to text using the instructions below (provide by
Stefan Blom).

2. Select the text and use Table | Convert | Text to Table, separating at
tabs (make sure the dialog shows that the result will be two columns.

3. Sort the resulting table on the second column.

4. Use Table | Convert | Table to Text, separating with tabs, to restore the
numbered list (you may need to reapply the hanging indent).

To convert autonumbering (paragraph/outline numbering and LISTNUM
fields) to plain text, do the following: Make sure the active
document is the one you want to convert. Then press ALT+F11 to
display the Visual Basic Editor. On the View menu, click
Immediate Window. In the Immediate Window, type

ActiveDocument.ConvertNumbersToText

and press ENTER.

Note that if paragraph/outline numbering was applied with styles,
it isn't completely gone (CTRL+Q will bring it back!) unless you
also clear it from the style definitions.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"fjrlem" <(E-Mail Removed)> wrote in message
news:97BA2E32-6654-4792-AB8B-(E-Mail Removed)...
>I have a list that is in numerical order. I need the list in alphabetical
> order however I need the corresponding numbers to stay with the words.
> This
> would make my numbers out of order. The list is numbered automaticly.
>



 
Reply With Quote
 
PJY
Guest
Posts: n/a
 
      3rd Feb 2009
highlight the entire list, then deselect numbering, sort the list, then
highlight the list again and select numbering

"fjrlem" wrote:

> I have a list that is in numerical order. I need the list in alphabetical
> order however I need the corresponding numbers to stay with the words. This
> would make my numbers out of order. The list is numbered automaticly.

 
Reply With Quote
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      3rd Feb 2009
The OP wants to keep the original numbers, however, so this won't work (and
it also wouldn't be necessary).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"PJY" <(E-Mail Removed)> wrote in message
news:18EBE43C-0E55-47EA-883D-(E-Mail Removed)...
> highlight the entire list, then deselect numbering, sort the list, then
> highlight the list again and select numbering
>
> "fjrlem" wrote:
>
>> I have a list that is in numerical order. I need the list in
>> alphabetical
>> order however I need the corresponding numbers to stay with the words.
>> This
>> would make my numbers out of order. The list is numbered automaticly.

>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ALPHABETIZE A NUMBERED LIST spondee Microsoft Word Document Management 5 21st Jun 2008 02:34 PM
create numbered sortable numbered list in excel =?Utf-8?B?Y29sb3JhZGlv?= Microsoft Excel Misc 2 15th Nov 2006 06:50 PM
How do I link a numbered list to a numbered heading? =?Utf-8?B?TmVsc29uIFNlbGluZ2Vy?= Microsoft Word Document Management 10 28th Jun 2006 10:12 PM
How do I continue a numbered list from a numbered heading? =?Utf-8?B?VHJhY3kgaW4gTWFuc2ZpZWxk?= Microsoft Word Document Management 3 29th Jul 2005 05:53 PM
How do I alphabetize numbered endnotes =?Utf-8?B?U2hlbGRvbiBDYW1wYmVsbA==?= Microsoft Word Document Management 1 8th Jul 2005 12:14 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:13 AM.