TOP

Camel Case Function for LibreOffice Calc

CAMELCASE() Description

The function CAMELCASE() is designed to combine words with a variable case of letters, that is, a single word is returned as a result, 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 code writing conventions (coding conventions) .


Main Features Functions CAMELCASE

Syntax:

=CAMELCASE(Text)

Parameters:

Example Usage

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

=CAMELCASE("Camel case function")

We will have the following result:

CAMELCASE formula usage

This example uses the following values:

Extension "YouLibreCalc.oxt"

You can use the CAMELCASE() function by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.