TOP

Pascal Case Function for LO Calc

PASCALCASE() Description

The PASCALCASE() function is designed to combine words in variable case, i.e. the result is one word, for example «PascalCaseFunction» .

Pascal Case breaks a string of words separated by spaces, hyphens, underscores, or case-shifted letters into individual elements. Then, it converts them all to uppercase words and combines them into a single word.

The PASCALCASE() function can be useful in programming to convert variable names according to accepted coding conventions. (coding conventions) .

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 of the PASCALCASE Function

Syntax:

=PASCALCASE(Text)

Parameters:

Example Usage

The PASCALCASE() function is easy to use. You just need to enter any text in the formula, and LO Calc automatically converts it to a new case:

=PASCALCASE(Text)

We will have the following result:

PASCALCASE formula usage

This example uses the following values:

Download extension

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