TOP

Kebab Case Function for Excel (Calc)

KEBABCASE() Description

The KEBABCASE() function is designed to combine words with hyphens, meaning that the result is a single word, for example «kebab-case-function».

Kebab Case breaks a string of words separated by spaces, hyphens, underscores, or changes in letter case, then converts these words to lowercase and combines them using a hyphen separator ("-").

The KEBABCASE() function can be useful in programming for converting variable names according to accepted code writing rules (coding conventions).

Also, you can use a set of ready-made tools "Other Case Options", that change the text case for selected cells with one click.


Key Features of the KEBABCASE Function

Syntax:

=KEBABCASE(Text)

Parameters:

Example of Use

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

=KEBABCASE(Text)

We will get the following result:

Example of using the KEBABCASE() function
Example of using the KEBABCASE() function

In this example, the following values are used:

Download extension

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

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


This function is also available in the following extensions: YLC LightYLC FunctionsYLC Utilities

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel