I'm new with excell....could you be REALLY specific
"Bob Phillips" wrote:
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"
|