Sentence Case Function for Excel

SENTENCECASE() Description

The SENTENCECASE() function 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 lowercase except for the first letter in the sentence and then combines all elements into one continuous text.

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

Main Features Functions SENTENCECASE

Syntax:

=SENTENCECASE(Text)

Parameters:

• Text: Any text in which you need to change the case of letters.

Example Usage

The SENTENCECASE() function is easy to use. All you have to do is enter any text into the formula and Excel will automatically convert it to a new case:

=SENTENCECASE("Sentence case. sEnTeNcE Case! SENTENCE CASE?")

We will have the following result:

This example uses the following values:

• Text: A2 - Text with words in different case.

Download the extension

You can use the SENTENCECASE() function by installing the free extension YouLibreCalc.xlam .

After that, this function will be available in all files that will be opened in Excel.