Title Case Function for LibreOffice Calc

TITLECASE() Description

The function TITLECASE() is designed to convert existing text into title case and returns a set of words in the form: "Function for Title Case".

The Title Case function code replaces separators such as hyphens and underscores with spaces, converts all words to uppercase, and converts conjunctions to lowercase.

Title Case can be useful for case correction in news headlines, site article titles, or YouTube video titles.

TITLECASE() is similar to the standard PROPER() function, except that conjunctions are not capitalized.

Main Features Functions TITLECASE

Syntax:

=TITLECASE(Text)

Parameters:

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

Example Usage

The TITLECASE() 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:

=TITLECASE("function for title case")

We will have the following result:

This example uses the following values:

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

Extension "YouLibreCalc.oxt"

You can use the TITLECASE() function by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.