Alphabetizing without 'The'

Question

I alphabetized a table in word, that contains some names as data that beings with 'The'. Is there anyway to ignore the 'The' at the beginning of these entries and sort by the next word after the 'the'?

Example of how my table is:

Random A

Random B

Random E

The Random C

The Random D

Example of what I want:

Random A

Random B

The Random C

The Random D

Random E

Answer 1

I alphabetized a table in word, that contains some names as data that beings with 'The'. Is there anyway to ignore the 'The' at the beginning of these entries and sort by the next word after the 'the'?

Example of how my table is:

Random A

Random B

Random E

The Random C

The Random D

Example of what I want:

Random A

Random B

The Random C

The Random D

Random E

 In case you haven't looked at Greg's page, it is the answer. You can't do this in Word as is, you have to modify it. Greg's page tells you how to do this.

Answer 2

http://gregmaxey.mvps.org/word_tip_pages/sorting_lists_(macro_methods).html