View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
masterdiablo13 masterdiablo13 is offline
external usenet poster
 
Posts: 3
Default Sort text list by character length - how?

Hi!
I am an excel newbie.
I have a text list of last names that I need to sort by character
length. Not alphabetically, I know how to do that, but by number of
letters in the name.
Example, if I have the following list
LAW
OROZCO
MCALLISTER
LUGO
DAVIES
SHOEMAKER
MADISON
RUTHERFORD
NEWSOME
MAGEE

I would need it sorted to

LAW
LUGO
MAGEE
DAVIES
OROZCO
MADISON
NEWSOME
SHOEMAKER
MCALLISTER
RUTHERFORD

I have roughly 75,000 names I am working with, in bunches of 200, so
being able to sort by character length will help me tremendously and
speed things up.
Any help with this is appreciated greatly!
chris