The KEBABCASE() function is designed to combine words using a hyphen, i.e. a single word is returned as a result, e.g.
Kebab Case splits a string of words separated by spaces, hyphens, underscores, or case changes, then converts the words to lowercase and joins them with a hyphen separator ("-").
The KEBABCASE() function can be useful in programming to convert variable names according to accepted code writing conventions
=KEBABCASE(Text)
The KEBABCASE() 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:
=KEBABCASE("Kebab case function")
We will have the following result:
This example uses the following values:
You can use the KEBABCASE() function by installing the free extension YouLibreCalc.xlam .
After that, this function will be available in all files that will be opened in Excel.