excel help - how can I sort a list by length

[MediaHound]

I have a large list of names, all mixed up lengths.
I wish to open the list in excel, then sort the list of domains by length.
Have the 2 char domains at the top, followed by the three char, then 4 and so on and so forth.
Could anyone give any clues?

 

[Honan]

I have a large list of names, all mixed up lengths.
I wish to open the list in excel, then sort the list of domains by length.
Have the 2 char domains at the top, followed by the three char, then 4 and so on and so forth.
Could anyone give any clues?

Put the list in column A
In Column B Row 1 type =LEN(A1) This gives you the length of A1
Edit Fill down B1 down Column B so you have =LEN(A2) etc
Copy, paste special, Values only , Column B
Highlight all
Now, data sort

Clears as mud?

 

[MediaHound]

In Column B Row 1 type =LEN(A1) This gives you the length of A1
Edit Fill down B1 down Column B so you have =LEN(A2) etc

little muddy - but this info was enough to get me unstuck

brilliant

thanks

 

[ryanmlanane]

I hate excel, but how do I "Edit Fill down B1 down Column B so you have =LEN(A2) etc"

I got the first part, easy ... <Noob> !

 

[silentg]

Thread is 6+ years old

 

[dmyre]

Thread is 6+ years old

It's still useful though.
This isn't something that I would have thought to search for.

 

[ryanmlanane]

It's still useful though.
This isn't something that I would have thought to search for.

Found it on Google

SilentG - I know what would make you happy. Buying 93games.com from me