Remember Me?

#1
May 2nd 05, 11:28 PM
 Kinger Posts: n/a
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
May 2nd 05, 11:36 PM
 David McRitchie Posts: n/a

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
May 2nd 05, 11:42 PM
 JE McGimpsey Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Excel Discussion (Misc queries) 1 January 16th 05 08:13 PM Jayne Excel Discussion (Misc queries) 1 January 6th 05 05:34 PM pugsly8422 Excel Worksheet Functions 4 January 3rd 05 06:07 PM Lisa D.N.1 Excel Worksheet Functions 1 December 28th 04 08:37 PM max Excel Worksheet Functions 1 November 29th 04 10:33 PM

All times are GMT +1. The time now is 09:03 PM.