Title Case Function for Excel (Calc)

TITLECASE() Description

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

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

Title Case can be useful for correcting the letter case 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.

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

Key Characteristics of the TITLECASE Function

Syntax:

=TITLECASE(Text)

Parameters:

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

Example Usage

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

=TITLECASE(Text)

We will have the following result:

In this example, the following values are used:

• 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.

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