Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you sort words in Excel by the number of letters in a word
I have a list of 5,000 words that I need sort by the number of letters in the
word for my students is this possible to do? The words range from 1 letter to 9 letters in a word. |
#2
|
|||
|
|||
with the use of a helper column
=LEN(A1) if you do not want to count spaces =LEN(SUBSTITUTE(A1," ","")) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kinger" wrote in message ... I have a list of 5,000 words that I need sort by the number of letters in the word for my students is this possible to do? The words range from 1 letter to 9 letters in a word. |
#3
|
|||
|
|||
in another column (say, column B) enter:
B1: =LEN(A1) and copy down as far as necessary. Sort columns A:B using column B as the sort key. In article , Kinger wrote: I have a list of 5,000 words that I need sort by the number of letters in the word for my students is this possible to do? The words range from 1 letter to 9 letters in a word. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Why have I got some repeating rows after a Excel 2003 sort | Excel Discussion (Misc queries) | |||
How do I pick a number from a list in Excel? | Excel Worksheet Functions | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
How do I set up a field in an Excel form to number it incremental. | Excel Worksheet Functions |