Sort text list by character length - how?

  • Thread starter Thread starter masterdiablo13
  • Start date Start date
M

masterdiablo13

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
 
Maybe you could use a helper column with a bunch of formulas that return the
length of the string. Then sort your data by that column.

=len(a1)

will return the number of characters in a1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can data be sorted by the length in a field 3
How do I sort a column by last character 2
How do I sort a large column of data by length? 3
sorting by character 7
How do I sort addresses in excel? 4
Sorting Columns by number of characters 1
How to sort column data regardless of col length 2
Sort by town name, which follows first name and initial; period; andcomma. 3

Back
Top