Camel Case Function for Excel (Calc)

CAMELCASE() Description

The CAMELCASE() function is designed to combine words with varying letter cases, meaning it returns a single word, for example «camelCaseFunction».

Camel 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 initial capital letter, except for the first one, which is converted to lowercase, and merges all elements into a single word.

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

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

Main Characteristics of the CAMELCASE Function

Syntax:

=CAMELCASE(Text)

Parameters:

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

Example of Usage

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

=CAMELCASE(Text)

We will get the following result:

The following values are used in this example:

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

Download extension

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

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