The CLEANTEXT() function is designed to clean text from all characters except letters.
=CLEANTEXT(Text)
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:
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).