How can I sort/order rows by number of words in each row

[AcornTree1]

Each row has a number of words.
I want them sorted by row with least number of words to highest.

[mikekaganski]

What “row has a number of words” means exactly? Several cells with one word per cell? a sentence of variable length in a cell/multiple cells? empty cells in the middle possible?

[AcornTree1]

**Unsorted **

1. be the first
2. today is
3. up
4. make some bread this evening
5. bay town

List Reordered by number of words in each row:

1. up
2. today is
3. bay town
4. be the first
5. make some bread this evening

Hope this is clearer

[gregors15]

Hi try the following, =LEN(A3)-LEN(SUBSTITUTE(A3," ", )) this will give the number blanks in the cell, which you can then sort on. See attached
LOQ_20200619a.ods

[AcornTree1]

gregors15

Thank you so much. Works perfectly!