TOP

CleanText function for LibreOffice Calc

YLC Utilities logo

CLEANTEXT() Description

The CLEANEXT() function is designed to clean text from all characters except letters.


Main Features Functions CLEANTEXT

Syntax:

=CLEANTEXT(Text)

Parameters:

Example Usage

The CLEANTEXT() function is easy to use. You just need to enter any text and LibreOffice Calc will automatically clean it of all characters except letters of the alphabet:

=CLEANTEXT("Invoice #100235 (21.05.23)")

We will have the following result:

CLEANTEXT formula usage

This example uses the following values:

Extension "YouLibreCalc.oxt"

You can use the CLEANEXT() function by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.