How do I sort a large column of data by length?

B

blange

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!
 
R

Ron Rosenfeld

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!
Click to expand...

If your domain names are in A2:A20000, then

B2: =LEN(A2)

Fill down to B20000

Sort on Column B.

--ron
 
B

blange

Thank you very much Ron!
Perfect results....


Ron Rosenfeld said:
If your domain names are in A2:A20000, then

B2: =LEN(A2)

Fill down to B20000

Sort on Column B.

--ron
Click to expand...
 

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

Select 'Sort By' column by simply typing heading letter 1
How to sort column data regardless of col length 2
Sort text list by character length - how? 2
Sort Date Column 3
Help! Need to compare 2 sets of data 1
How do I include names in formula by picking up names from rows 6
excel 2011 won't sort alphabetically 7
Sort a range of strings using VBA code? 5

Top