Sentence Case Function for Excel (Calc)

SENTENCECASE() Description

The SENTENCECASE() function is designed to convert existing text into sentence format and returns a set of words in the form of: «Sentence case function».

Sentence Case breaks down lines separated by periods, exclamation marks or question marks into separate sentences. Then, it converts all words to lowercase, except for the first letter in the sentence, followed by merging all elements into one continuous text.

The SENTENCECASE() function can be useful for correcting letter case in sentences throughout the text.

Also, you can use a set of ready-made tools "Other Case Options", which change the text case for selected cells in one click.

Main Characteristics of the SENTENCECASE Function

Syntax:

=SENTENCECASE(Text)

Parameters:

• Text: Any text in which the letter case needs to be changed.

Example of Use

The SENTENCECASE() function is easy to use. You just need to enter any text into the formula, and Excel (Calc) automatically converts it to the new case:

=SENTENCECASE(Text)

We will get the following result:

The following values are used in this example:

• Text: A2 - Text with words in different cases ("Sentence case. sEnTeNcE Case! SENTENCE CASE?").

Download extension

You can use the function SENTENCECASE() by installing the extension YLC Utilities.

After this, this function will be available in all files that will be opened in Excel (LibreOffice Calc).