Link to home
Start Free TrialLog in
Avatar of Leprechaun
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
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

SELECT Sentence
FROM Sentences
ORDER BY LEN(Sentence)
What sort of table - database, Excel, Word?
Avatar of Leprechaun
Leprechaun

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 :)
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Forced accept.

Computer101
EE Admin