Cross-posted at:
Sort by String Length and
Sort by String Length
For cross-posting etiquette, please read:
Excelguru Help Site - A message to forum cross posters
To do the sorting, you need to temporarily add a column to the table and add the string lengths to that, before sorting via the added column. For some code that does most of what you need, see:
vba - How can I sort a word table by specific string, which is a time like HH:MM inside each line of the first column - Stack Overflow