T
tekz999
Guest
Which program can sort lines according to number of characters?
Membership is FREE – with unlimited access to all features, tools, and discussions. Premium accounts get benefits like banner ads and newsletter exposure. ✅ Signature links are now free for all. 🚫 No AI-generated (LLM) posts allowed. Share your own thoughts and experience — accounts may be terminated for violations.
- 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
