RE: Alphabetize a sort.

Giganews Newsgroups
Subject: RE: Alphabetize a sort.
Posted by:  dlw
Date: Sat, 6 May 2006

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

Replies

In response to

Alphabetize a sort. posted by TomK on Sat, 6 May 2006