Camel Case Function for Excel

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:

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

Example Usage

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

=CAMELCASE("Camel case function")

We will have the following result:

This example uses the following values:

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

Download the extension

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

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