| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Special Sort Help
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Special Sort Help
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Special Sort Help
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) "James E Middleton" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Special sort for oldest and newest date | Excel Discussion (Misc queries) | |||
| 3 level sort, last special order | Excel Worksheet Functions | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| Zip code sort is an Excel problem even when using the special cat. | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Linear Mode
