View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw
 
Posts: n/a
Default Alphabetize a sort.

no, you would have to make a "dummy" column with a function like
=if(left(a1,3)="The",mid(a1,5,len(a1)),a1)
and sort on it.

or, make it =if(left(a1,3)="The",mid(a1,5,len(a1))&", The",a1)
that would turn The Cat into Cat, The

"Tomk" wrote:

is it possable in Excel to sort a list of names and ignore the word "the" in
a name.??? that is "the Cat" would be sorted as if it started with the
letter C...
--
Tomk