Remove other characters

Text > Remove other characters

A set of tools that remove unnecessary characters from the text in the selected cells. These utilities are used to clear data from extra signs punctuation, spaces, special characters, etc. This simplifies the preparation of data for analysis or further processing, making them more pure and structured.

You can clear the text in the selected use of the following utilities:

• Remove everything except the letters (a-z)
• Remove everything except the numbers (0-9)
• Delete all except symbols of a word (abc123_)
• Delete all except symbols of a sentence (abc 123_.,!?)

Screen shot

Starting this tool

Click YLC Utilities > Text > Remove other characters :

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use Excel, the amount of data you work with and how often you use this tool.

Download extensions

You can use the utility Remove other characters by installing the extension YLC Utilities .

This feature will be available in all files that will be opened in Excel.