Snake Case Function for Excel

SNAKECASE() Description

The SNAKECASE() function is designed to combine words using underscores, i.e. it returns a single word, e.g. «snake_case_function» .

Snake Case splits a string of words separated by spaces, hyphens, underscores, or case changes, then converts those words to lowercase and concatenates them with an underscore separator ("_").

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

Main Features Functions SNAKECASE

Syntax:

=SNAKECASE(Text)

Parameters:

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

Example Usage

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

=SNAKECASE("Snake 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 SNAKECASE() function by installing a free extension YouLibreCalc.xlam .

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