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.
First time here? Check out the FAQ!
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
gregors15
Thank you so much. Works perfectly!
Asked: 2020-06-19 09:13:51 +0100
Seen: 77 times
Last updated: Jun 19 '20
Is there an automatic sort function in Calc? [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]
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