|Subject:||RE: Alphabetize a sort.|
|Date:||Sat, 6 May 2006|
no, you would have to make a "dummy" column with a function like
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
> 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...
Alphabetize a sort. posted by TomK on Sat, 6 May 2006