I'll try to be more clear

What I want, is for excel to sort based on 2 words...so, if the field
has 2 words, I want that at the top, if the field has more then 2 words
I want that at the bottom...in no particular order, just simply by 2
words

Edit: I can go into the options and set a custom list, all i'm looking
for is the formula to tell excel sort by A B, A B C, A B C D
etc

And the A and B are variables, they can be anything


--
Caden
------------------------------------------------------------------------
Caden's Profile: http://www.excelforum.com/member.php...o&userid=27252
View this thread: http://www.excelforum.com/showthread...hreadid=467583