I need to remove white space or empty paragraphs;
"text text text
text text text"
to;
text text text
text text text"
1 column, many cells.
Thank you,
⌡im
That did it !
Thanks,
⌡im
menu:Find&Replace…
Other Options
[X] Regular expressions
Search: ^\s*$
Replace: [nothing, nada, empty]
Click [Replace All] to remove all white space from blank paragraphs
Then modify the search expression to: ^$ and click [Replace All] which removes the completely blank paragraphs.
Doesn’t work in CALC
I appreciate the try, though …
⌡im
Sorry, I did not notice the Calc tag.
Oh, wait a moment. I found something interesting:
Search: \n(\n)
Replace: $1