TOP

Snake Case Function for Excel (Calc)

SNAKECASE() Description

The SNAKECASE() function is designed to combine words using underscores, i.e. the result is one word, for example «snake_case_function» .

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

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

Syntax:

=SNAKECASE(Text)

Parameters:

Example Usage

The SNAKECASE() function is easy to use. You just need to enter any text into the formula, and Excel (Calc) automatically converts it to a new case:

=SNAKECASE(Text)

We will have the following result:

SNAKECASE formula usage

This example uses the following values:

Download extension

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

Or its free version YouLibreCalc .

Or its free version YouLibreCalc .

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