Function CleanText

CLEANTEXT() Description

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

Main Characteristics of the CLEANTEXT Function

Syntax:

=CLEANTEXT(Text)

Parameters:

• Text: Text to be cleaned from non-alphabetic characters.

Example of Use

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

=CLEANTEXT(Text)

We will get the following result:

In this example, the following values are used:

• Text: A2 - Text for cleaning ("Invoice #100235 (21.05.23)").

Download extension

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

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