PascalCase Function

PASCALCASE() Description

The PASCALCASE() function is designed to combine words with variable letter case, that is, as a result, one word is returned, for example «PascalCaseFunction».

Pascal Case breaks a string of words, separated by spaces, hyphens, underscores, or varying letter cases, into individual elements. Then, it converts all of them into words with an uppercase letter and combines them into one word.

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

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

Key Features of the PASCALCASE Function

Syntax:

=PASCALCASE(Text)

Parameters:

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

Usage Example

The PASCALCASE() function is easy to use. You just need to enter any text into the formula, and Excel (Calc) will automatically convert it to the new case:

=PASCALCASE(Text)

We will have the following result:

In this example, the following values are used:

• Text: A3 - Text with words in different cases ("Pascal case function").

Download extension

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

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