Title Case Function for LO Calc

TITLECASE() Description

The TITLECASE() function is designed to convert existing text into heading format 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 correcting the case of letters in news headlines, website article titles, or YouTube video titles.

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

You can also use a set of ready-made tools "Other register options" , which change the text case for selected cells in one click.

Main Features TITLECASE Functions

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 into the formula, and LO Calc automatically converts it to a new case:

=TITLECASE(Text)

We will have the following result:

This example uses the following values:

• Text: A2 - Text with words in different cases ("function for title case") .

Download extension

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

Or its free version YouLibreCalc .

After that, this function will be available in all files that are opened in LibreOffice Calc .