Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Inverting a list
Is there a simple way to automatically invert a list. That is...
A B C D changed to... D C B A in a standard list format or in a table. I have frequent need of this in page long lists. These lists are copied and pasted, so that generating line numbers and sorting on those doesn't seem to work, unless I am doing it wrong. Any help or suggestions would be appreciated. Thanks in advance. -- Norm Shimmel Butler, PA |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Inverting a list
Table sort works in tables and with paragraphs. You can set the sort to be
ascending of descending. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NES wrote: Is there a simple way to automatically invert a list. That is... A B C D changed to... D C B A in a standard list format or in a table. I have frequent need of this in page long lists. These lists are copied and pasted, so that generating line numbers and sorting on those doesn't seem to work, unless I am doing it wrong. Any help or suggestions would be appreciated. Thanks in advance. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Inverting a list
Thanks for the reply.
The data is neither alphabetically nor numerically in order to begin with. Sorting on that data would not give me what I need. If there were some way to automate the SPIKE function in a backward fashion, that would work. s The point of all of this is an item to item comparrison of data in another list that I can't alter. With the lists going it opposite directions it makes things a little more confusing for this old brain of mine. -- Norm Shimmel Butler, PA "Graham Mayor" wrote: Table sort works in tables and with paragraphs. You can set the sort to be ascending of descending. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NES wrote: Is there a simple way to automatically invert a list. That is... A B C D changed to... D C B A in a standard list format or in a table. I have frequent need of this in page long lists. These lists are copied and pasted, so that generating line numbers and sorting on those doesn't seem to work, unless I am doing it wrong. Any help or suggestions would be appreciated. Thanks in advance. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Inverting a list
Select the list and add autonumbering.
Use the following macro to change the numbers to text Sub NumbersAutoToText() ActiveDocument.ConvertNumbersToText End Sub Sort the list in descending order then use replace to remove the numbers. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NES wrote: Thanks for the reply. The data is neither alphabetically nor numerically in order to begin with. Sorting on that data would not give me what I need. If there were some way to automate the SPIKE function in a backward fashion, that would work. s The point of all of this is an item to item comparrison of data in another list that I can't alter. With the lists going it opposite directions it makes things a little more confusing for this old brain of mine. Table sort works in tables and with paragraphs. You can set the sort to be ascending of descending. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NES wrote: Is there a simple way to automatically invert a list. That is... A B C D changed to... D C B A in a standard list format or in a table. I have frequent need of this in page long lists. These lists are copied and pasted, so that generating line numbers and sorting on those doesn't seem to work, unless I am doing it wrong. Any help or suggestions would be appreciated. Thanks in advance. |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Inverting a list
Thank you very much. THis is a keeper.
-- Norm Shimmel Butler, PA "Graham Mayor" wrote: Select the list and add autonumbering. Use the following macro to change the numbers to text Sub NumbersAutoToText() ActiveDocument.ConvertNumbersToText End Sub Sort the list in descending order then use replace to remove the numbers. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NES wrote: Thanks for the reply. The data is neither alphabetically nor numerically in order to begin with. Sorting on that data would not give me what I need. If there were some way to automate the SPIKE function in a backward fashion, that would work. s The point of all of this is an item to item comparrison of data in another list that I can't alter. With the lists going it opposite directions it makes things a little more confusing for this old brain of mine. Table sort works in tables and with paragraphs. You can set the sort to be ascending of descending. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NES wrote: Is there a simple way to automatically invert a list. That is... A B C D changed to... D C B A in a standard list format or in a table. I have frequent need of this in page long lists. These lists are copied and pasted, so that generating line numbers and sorting on those doesn't seem to work, unless I am doing it wrong. Any help or suggestions would be appreciated. Thanks in advance. |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Inverting a list
You are welcome
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NES wrote: Thank you very much. THis is a keeper. Select the list and add autonumbering. Use the following macro to change the numbers to text Sub NumbersAutoToText() ActiveDocument.ConvertNumbersToText End Sub Sort the list in descending order then use replace to remove the numbers. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NES wrote: Thanks for the reply. The data is neither alphabetically nor numerically in order to begin with. Sorting on that data would not give me what I need. If there were some way to automate the SPIKE function in a backward fashion, that would work. s The point of all of this is an item to item comparrison of data in another list that I can't alter. With the lists going it opposite directions it makes things a little more confusing for this old brain of mine. Table sort works in tables and with paragraphs. You can set the sort to be ascending of descending. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NES wrote: Is there a simple way to automatically invert a list. That is... A B C D changed to... D C B A in a standard list format or in a table. I have frequent need of this in page long lists. These lists are copied and pasted, so that generating line numbers and sorting on those doesn't seem to work, unless I am doing it wrong. Any help or suggestions would be appreciated. Thanks in advance. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inverting text in text boxes | Page Layout | |||
Inverting a Table of Contents (similar to pivot table) | Formatting Long Documents | |||
Inverting text | Microsoft Word Help | |||
Word 2003 replaces list of tables when inserting list of figures | New Users | |||
Import Outlook 2003 distribution list to mail merger recipents list | Mailmerge |