| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alphabetize a sort.
=SUBSTITUTE(A2;"The ";"")
Cordialy JB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a column in alpha order? | New Users to Excel | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Linear Mode
