[NES]

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

[Graham Mayor]

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.

[NES]

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.

[Graham Mayor]

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.

[NES]

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.

[Graham Mayor]

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.