Break Case Function for Excel (Calc)

BREAKCASE() Description

The BREAKCASE() function is designed to split text with delimiters into separate words, i.e. 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 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 of BREAKCASE Functions

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 into the formula, and Excel (Calc) automatically converts it to a new case:

=BREAKCASE(Text)

We will have the following result:

This example uses the following values:

• Text: A2 - Text with words in different cases ("Break case function") .

Download extension

You can use the function BREAKCASE() 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) .