Is there a way to write a formula that will break a block of text into chunks by word count? If not, maybe splitting it in half?

Split Text in half or by word count

Rickard_Abraham December 11, 2022, 4:57am 7

Got a working example for you, it was a bit trickier than anticipated but works nicely now!

3 Likes

Topic		Replies	Views
Count Words Used in text	4	466	March 3, 2023
Finding the first word and last word in a string - use case: splitting full name into first and last name	7	1280	May 16, 2022
A novel writing helper ideas? (Split formula?)	11	2638	December 5, 2019
Text Normalizer [Its so cool]	5	630	September 8, 2022
Find multiple values (CSV column) in text string	7	1298	May 30, 2022