The KEBABCASE() function is designed to combine words using a hyphen, i.e. it returns a single word, for example "kebab-case-function".
Kebab Case splits a string of words separated by spaces, hyphens, underscores, or case changes, then converts those 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
Here is the macro code to create a custom function that can convert text to individual words separated by hyphens (Kebab Case) in LibreOffice Calc.
Open the menu Tools - Macros - Edit Macros..., select Module1 and copy the following text into the module:
Function KebabCase(ByVal str As String) As String 'moonexcel.com.ua Dim words As Variant Dim FCalc As Object FCalc = CreateUnoService("com.sun.star.sheet.FunctionAccess") str = Replace(str,"-"," ") str = Replace(str,"_"," ") str = FCalc.callFunction("TRIM", Array(str)) str = FCalc.callFunction("REGEX", Array(str,"([:lower:])([:upper:])","$1 $2","g")) str = LCase(str) words = Split(str," ") KebabCase = Join(words,"-") End Function
Then close Macro Editor, return to LibreOffice Calc and use our new function in any cell.
You can also use the KEBABCASE() function by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.