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
|