LinkBack URL
About LinkBacks
I want to sort a lot of lines (about 50k) from a notepad in order of how many letters contain each line.
At the end I want my lines to look like
x
xx
xxx
xxxx
xxxxx
xxxxxx
xxxxxxx
and so on
Can someone explain me how to do this ?
thank you
How to sort lines in order of number of letters
I want to sort a lot of lines (about 50k) from a notepad in order of how many letters contain each line.
At the end I want my lines to look like
x
xx
xxx
xxxx
xxxxx
xxxxxx
xxxxxxx
and so on
Can someone explain me how to do this ?
thank you
Last edited by wizi; 09-06-2011 at 04:31 AM.
Add one more column, use =LEN(A1) and sort by that column
Never use Merged Cells in Excel
thank you
I used that code in and I got in B column the number of characters of each line from the first column.
Now I have something like: 26,43,32,41,33,19,7 etc
But how do I order them to get an ascending column like: 5,6,8,12,19,24 etc
Add header column and in that column add Filter (Data -> Filter).
then sort by it.
Or select some cell in B column, Select all and right click -> Sort
You need to sort that column using the sort function.
Select both the columns
Go to sort
Then select "Sort by Column B"
thank you. it worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks