View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blange
 
Posts: n/a
Default How do I sort a large column of data by length?

I have an excel spreadsheet with about 20,000 rows of domain names in one
column. I need to sort the huge list by the length of each domain name --
shortest first. Example:

d4.com
tyu.com
dh4.net
sjrh.com
h669.com
short.com
shorter.com

and so on........ all the way down through 20K names. Thank you for any help!