The function SENTENCECASE() is designed to convert existing text into sentence format and returns a set of words in the form: "Sentence case function".
Sentence Case breaks lines separated by periods, exclamation points, or questions into separate sentences. Then, converts all words to lower case except for the first letter in the sentence and then merges all elements into one continuous text.
The SENTENCECASE() function can be useful for correcting the case of letters in sentences throughout the text.
=SENTENCECASE(Text)
The SENTENCECASE() function is easy to use. You just need to enter any text in the formula and LibreOffice Calc automatically converts it to a new case:
=SENTENCECASE("Sentence case. sEnTeNcE Case! SENTENCE CASE?")
We will have the following result:
This example uses the following values:
You can use the function SENTENCECASE() by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.