Break Case Function for LibreOffice Calc

BREAKCASE() Description

The function BREAKCASE() is designed to break text with separators into separate words, that is, the function returns the result in the following format: "break case function".

Break Case first breaks a string of words separated by a space, hyphen, or underscore into individual elements, then converts all words to lowercase and combines them into a single sentence with an empty separator (" ").

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

Main Features Functions BREAKCASE

Syntax:

=BREAKCASE(Text)

Parameters:

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

Example Usage

The BREAKCASE() function is easy to use. You just need to enter any text in the formula and LibreOffice Calc automatically converts it to a new case:

=BREAKCASE("Break case function")

We will have the following result:

This example uses the following values:

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

Extension "YouLibreCalc.oxt"

You can use the BREAKCASE() function by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.