Camel Case Function for LO Calc

CAMELCASE() Description

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

Camel Case splits a string of words separated by spaces, hyphens, underscores, or letter case into separate elements. Then, it converts all of these to uppercase words except the first one, which is converted to lowercase, and combines all the elements into one word.

The CAMELCASE() 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 CAMELCASE Functions

Syntax:

=CAMELCASE(Text)

Parameters:

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

Example Usage

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

=CAMELCASE(Text)

We will have the following result:

This example uses the following values:

• Text: A2 - Text with words in different cases ("Camel case function") .

Download extension

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