Alphabetize a sort.
 

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

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

Alphabetize a sort.
 

correction- replace len(a1) with len(a1)-4

"dlw" wrote:

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

Alphabetize a sort.
 

If every row began with "the", you could separate "the" from the rest of the text and place it in an adjacent column and then sort.
When that is done you could re-attach "the" to the sorted text. Also, if only some of the rows have "the" at the start, you could
use auto-filter on the rows and get just the rows which have "the" at the beginning and then massage the filtered rows to eliminate
the problem word.

--
RMC,CPA


"Tomk" wrote in message ...
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

Alphabetize a sort.
 

A commercial alternative from your truly...
http://www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USA


"Tomk"
wrote in message
is it possible 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

Alphabetize a sort.
 

Is there also a version that will work in access????
--
Tomk


"Jim Cone" wrote:

A commercial alternative from your truly...
http://www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USA


"Tomk"
wrote in message
is it possible 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

Alphabetize a sort.
 

I do not have any Access add-ins.
I believe Access has sorting capabilities that are different from Excel.
You might want to double check what Access has available.
Sincerely,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Tomk"
wrote in message
...
Is there also a version that will work in access????
Tomk


"Jim Cone" wrote:
A commercial alternative from yours truly...
http://www.officeletter.com/blink/specialsort.html
Jim Cone
San Francisco, USA


"Tomk"
wrote in message
is it possible 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

Alphabetize a sort.
 

Thank you. After our weekend with the kids and grand kids, I will get back to
you to purchase the Excel add-in.
--
Tomk


"Jim Cone" wrote:

I do not have any Access add-ins.
I believe Access has sorting capabilities that are different from Excel.
You might want to double check what Access has available.
Sincerely,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Tomk"
wrote in message
...
Is there also a version that will work in access????
Tomk


"Jim Cone" wrote:
A commercial alternative from yours truly...
http://www.officeletter.com/blink/specialsort.html
Jim Cone
San Francisco, USA


"Tomk"
wrote in message
is it possible 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

Alphabetize a sort.
 

=SUBSTITUTE(A2;"The ";"")

Cordialy JB