T
tekz999
Guest
Which program can sort lines according to number of characters?
-
Welcome to DNForum.com - Domain Investor Forum, Free Domain Marketplace and a community for 45+ domain pros
If you are new to domains and looking to buy, sell and learn about domains then you have come to the right place. DNForum is the oldest global domain name community on the internet and continues to grow every day. There are over 45,000 domainers on DNForum doing everything from buying domains, selling domains, using our free in-house built tools, learning about domains and discussing domains. Take a minute and Register.
- Status
- Joined
- Nov 29, 2002
- Messages
- 1,550
- Reaction score
- 0
I have a slightly long-winded way of doing this which works for me
Enter the lines in paracas.com/dnlenght.php save the data to a txt file and then import into excel and sort by the second column (length).
p.s. I just realised that this only works for the part before the dot. where domain names are concerned. May not do what you want.
Enter the lines in paracas.com/dnlenght.php save the data to a txt file and then import into excel and sort by the second column (length).
p.s. I just realised that this only works for the part before the dot. where domain names are concerned. May not do what you want.
- Joined
- Nov 27, 2008
- Messages
- 65
- Reaction score
- 0
Try this in excel:
1) import text in one column (A)
2) use in the second column function: =len(a1)
3) drag edge of cell to fill all cells of B column with: =len(a2), len(a3), ... etc.
4) select A and B columns
5) Data->Sort
6) select Sort by: B
7) select Then by: A
And that's all.
1) import text in one column (A)
2) use in the second column function: =len(a1)
3) drag edge of cell to fill all cells of B column with: =len(a2), len(a3), ... etc.
4) select A and B columns
5) Data->Sort
6) select Sort by: B
7) select Then by: A
And that's all.
- Status
