The SNAKECASE() function is designed to combine words using underscores, i.e. the result is one word, for example
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.
You can also use a set of ready-made tools "Other register options" , which change the text case for selected cells in one click.
=SNAKECASE(Text)
The SNAKECASE() function is easy to use. You just need to enter any text into the formula, and LO Calc automatically converts it to a new case:
=SNAKECASE(Text)
We will have the following result:
This example uses the following values:
You can use the function SNAKECASE() by installing the extension
Or its free version YouLibreCalc .
After that, this function will be available in all files that are opened in LibreOffice Calc .