How can I sort/order rows by number of words in each row
Each row has a number of words. I want them sorted by row with least number of words to highest.
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 C:\fakepath\LOQ_20200619a.ods
Asked: 2020-06-19 09:13:51 +0100
Seen: 77 times
Last updated: Jun 19 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
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?
*Unsorted *
List Reordered by number of words in each row:
Hope this is clearer