Create a helper column and add this formula to it

=SUBSTITUTE(SUBSTITUTE(A20,"The ",""),"A ","")

Then sort both columns by the helper column

--
HTH

Bob Phillips

"Ronnie" wrote in message
...
ok...I have complied a list of my DVD collection and what I am trying to
do
is alphabatize the list. What problem I have when doing it is when I
click
sort button it always groups words like "A" and "The". I want it to
ignore
those words and focus on the word after "A" or "The"