Sort huge list: Shortest name to longest

[Gene]

I have a portfolio of around 1250 domains. Does anyone know of a way to sort this list from shortest domain to longest (number of characters) without manually editing the list? Thanks!

 

[nRnF]

copy it to Excel set a new colum with the "length" function, reorder by the new collumn - SET
My Excel is spanish, so here it is like =LARGO(A1)

 

[Gene]

Sounds good, but I'm not familiar with the count function. I imported a column of domain names. Now where do I go to use the count function you speak of? Thanks!

 

[nRnF]

I will prepare you the file and add it as attachment
gimme 5 min.

 

[IAmAllanShore]

So you have your column with all your names in it

In the next column over (Or skip one) in the first cell type " len(a1) " , if "a1" is your first cell with a domain name. If it's not, set it to whatever the correct cell is. That will count the number of letters in the domain.

Then, highlight the cell with the " len(a1) " in it and drag down (fill down) into all other 1,000+ cells (The fill down function will take 2 seconds, it's under the "edit" menu or you can hit "control-d".

Then sort your rows by the column with the lengths in them ( Data:Sort:Ascending:Column whatever it is - all self explanatory under the column menu ).

-Allan

 

[nRnF]

Here we go
I added also a feature to eliminate TLDs (count w/o TLDs & ccTLDs)

I hope my spanish excel converts well when you open it

 

[Gene]

So you have your column with all your names in it

In the next column over (Or skip one) in the first cell type " len(a1) " , if "a1" is your first cell with a domain name. If it's not, set it to whatever the correct cell is. That will count the number of letters in the domain.

Then, highlight the cell with the " len(a1) " in it and drag down (fill down) into all other 1,000+ cells (The fill down function will take 2 seconds, it's under the "edit" menu or you can hit "control-d".

Then sort your rows by the column with the lengths in them ( Data:Sort:Ascending:Column whatever it is - all self explanatory under the column menu ).

-Allan

I now have a second column with len(a1) in every line. Where does it show you the calculation, or the count of each line so I can sort? And shouldn't each line be different? (len(a1), len(a2), len(a3), etc?

confused!

Here we go
I added also a feature to eliminate TLDs (count w/o TLDs & ccTLDs)

I hope my spanish excel converts well when you open it

I'll try this now...

Here we go
I added also a feature to eliminate TLDs (count w/o TLDs & ccTLDs)

I hope my spanish excel converts well when you open it

Okay, you had some sample domains in there from a1 to a6. I imported my domains to fill a7 to a1250. Now how do I get it to do the calculation? Sorry for these seemingly dumb questions!

 

[nRnF]

Here comes Genes Domain Counter v1.1 (some call it also Excell for dummies)
Supports now 1300 names

Download it now FREE as v2.0 will be sold at 650 USD :hehe:

 

[Keynes]

Text to columns by "." to put extensions into their own column, then setup another column and in the first put =len(a1) then select that column, Fill-Down and you'll be set

 

[Gene]

Here comes Genes Domain Counter v1.1 (some call it also Excell for dummies)
Supports now 1300 names

Download it now FREE as v2.0 will be sold at 650 USD :hehe:

BINGO!

Thanks a million nRnF! And thanks to everyone else who offered advice. Rep given to you all!