Leprechaun
asked on
Sorting tabular data by length
Hi folks
I have a mulit-column table. One of the tables contains sentences, some short and others long.
I want to sort to the data by the *length of the sentences* in a particular column.
I don't see an option when I sort so I'm assuming this calls for VBA.
Thanks.
Leprechaun
I have a mulit-column table. One of the tables contains sentences, some short and others long.
I want to sort to the data by the *length of the sentences* in a particular column.
I don't see an option when I sort so I'm assuming this calls for VBA.
Thanks.
Leprechaun
What sort of table - database, Excel, Word?
ASKER
Oh, I'm sorry. It's a table in MS Word.
Leprechaun said:
>>Oh, I'm sorry. It's a table in MS Word.
Rules out my suggestion, then :)
>>Oh, I'm sorry. It's a table in MS Word.
Rules out my suggestion, then :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
FROM Sentences
ORDER BY LEN(Sentence)