Break Case Function for Excel

BREAKCASE() Description

The BREAKCASE() function is designed to split text with delimiters 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. All you have to do is enter any text into the formula and Excel will automatically convert 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.

Download the extension

You can use the BREAKCASE() function by installing a free extension YouLibreCalc.xlam .

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