First Case Function for LO Calc

FIRSTCASE() Description

The FIRSTCASE() function is designed to convert the first character in text to uppercase, for example «First case function» .

First Case converts only the first character in the text to uppercase, leaving all other letters unchanged.

FIRSTCASE() is similar to the function SENTENCECASE() , but differs in that only the first character in the entire text is changed.

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

Main Features of the FIRSTCASE Function

Syntax:

=FIRSTCASE(Text)

Parameters:

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

Example Usage

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

=FIRSTCASE(Text)

We will have the following result:

This example uses the following values:

• Text: A3 - Text with words in different cases ("total amount with VAT: 1000$") .

Download extension

You can use the function FIRSTCASE() 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 .