Pascal Case Function for Excel

PASCALCASE() Description

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

Pascal Case breaks a string of words separated by spaces, hyphens, underscores, or variable case letters into separate elements. Then, turns all of these into capitalized words and combines them into one word.

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

Main Features Functions PASCALCASE

Syntax:

=PASCALCASE(Text)

Parameters:

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

Example Usage

The PASCALCASE() function is easy to use. All you have to do is enter any text into the formula and Excel will automatically convert it to a new case:

=PASCALCASE("Pascal case function")

We will have the following result:

This example uses the following values:

• Text: A3 - Text with words in different case.

Download the extension

You can use the PASCALCASE() function by installing the free extension YouLibreCalc.xlam .

After that, this function will be available in all files that will be opened in Excel.