Hi ...,
You will probably need a macro (programming newsgroup)
but you can do the first part without a macro if you only have
two words to eliminate at the beginning -- you are limited to
a nesting level of 7. see
http://google.com/groups?threadm=efJ...TNGP14.phx.gbl
be sure to look at the original posting, (options, show original)
and make the window as wide as possible as the Google format
is likely to screw up formatting.

I think the second part would create as much confusion as
it might help you so might not be worth the effort.
Since there is nothing builtin to Excel,
you would have to isolate the numbers and convert them.
There are macros to expand numbers to words see links in
http://www.mvps.org/dmcritchie/excel...numberstowords
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JediLuke" <JediLuke.1u1tyc_1124517946.1787@excelforum-nospam.com> wrote in message
news:JediLuke.1u1tyc_1124517946.1787@excelforum-nospam.com...
>
> I am making an inventory of movies I have, and I would like the sort the
> list alphabetically.
>
> However many movie titles begin with 'a' or 'the' and I would like to
> know if words like these to be ignored when sorting.
>
> In addition, I would like to know if the sorter can treat numerical
> values as letters. For example, the film '28 Days Later' would be filed
> as if it were 'Twenty-Eight Days Later.'
>
> This is a simple single column list, I would only like titles to be
> sorted as if it were a library catalogue. If anyone knows the solution
> to my request, I would appreciate a response. Thanks.
>
>
> --
> JediLuke
> ------------------------------------------------------------------------
> JediLuke's Profile: http://www.excelforum.com/member.php...o&userid=26475
> View this thread: http://www.excelforum.com/showthread...hreadid=397443
>