Alphabetize a sort.

T

Tomk

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...
 
D

dlw

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
 
D

dlw

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

dlw said:
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
Click to expand...
 
R

R. Choate

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


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...
 
T

Tomk

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 said:
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" <[email protected]>
wrote in message
Is there also a version that will work in access????
Tomk
Click to expand...
 
Top