TOP

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:

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:

Example of using the CLEANTEXT() function
Example of using the CLEANTEXT() function

In this example, the following values are used:

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).


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