Special Sort Help

  • Thread starter Thread starter James E Middleton
  • Start date Start date
J

James E Middleton

I am looking for a way to sort word lists not alphabetically, but by the
number of letters in each word. (The alphabetical sort can be done after)
Could this be done in Excel?

Is my post OK here, or should I ask in another group?
 
Hi James,

You could insert a helper column. Say your data is in column D
in helper column E put =LEN(D1) grab the fill handle and drag
down to the end of your data, then sort on column E.

HTH
Martin
 
You will need a helper column with =LEN(A1) and fill it down for the list.
Then sort on this column
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 

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

Sort by Every Other Row? 0
How to sort entire spreadsheet by one column sort 5
Sorting formula cells not same as sort of value cells? Yikes! 4
Columns not sorting properly. 2
Sorting 1
Sorting alphanumeric data at 2nd, 3rd or 4th character position 5
Sort in Greek alphabetical order 2
Prevent SORT from asking to expand selection in Excel 2007? 4

Back
Top