TOP

CleanText function for Excel

CLEANTEXT() Description

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


Main Features Functions CLEANTEXT

Syntax:

=CLEANTEXT(Text)

Parameters:

Example Usage

The CLEANTEXT() function is easy to use. All you have to do is enter any text and Excel will automatically strip it of all characters except letters of the alphabet:

=CLEANTEXT(Text)

We will have the following result:

CLEANTEXT formula usage

This example uses the following values:

Download the extension

You can use the CLEANTEXT() function by installing a free extension YouLibreCalc.xlam .

After that, this function will be available in all files that will be opened in Excel.