Data Cleaning
The Data Cleaning functionality provides a range of tools to manipulate and clean data within selected cells. It is accessed from the EasySheet Pro ribbon and opens a side panel displaying all available operations.
Notes
Every operation can be undone using the UNDO button in the EasySheet Pro ribbon.
Changes are applied immediately to the selected cells.
Some operations require additional input (e.g., character to remove, prefix to add).
For operations that generate new data (e.g., Extract Numbers, Extract Email Domain), you will be prompted to select a destination cell.
Undo/Redo function is available for all supported modifications.
How to Use
Click the button in the ribbon to open the side panel.
Select the cells you want to modify.
Click on the desired operation in the panel.
Available Operations
- Remove Extra Space – Eliminates multiple spaces and trims leading/trailing spaces
- Remove Non-Printable Characters – Deletes invisible and control characters
- Remove Specific Character – Removes specified characters from text
- Reverse Text – Reverses the order of characters in selected cells
- Handle Missing Value – Replaces empty cells with “N/A”
- Check Digit Count – Highlights cells with an inconsistent number of digits
- Convert Words to Numbers – Transforms text-based numbers into numerical values (e.g., “one hundred and twenty-three” → “123”)
- Convert Numbers to Words – Converts numbers into written text (e.g., “123” → “one hundred and twenty-three”)
- Add Prefix – Inserts text at the beginning of each cell
- Add Suffix – Appends text to the end of each cell
- Remove Non-Alphanumeric – Keeps only letters and numbers, removing symbols
- Extract Numbers – Copies only numerical values into a new range
- Remove Leading Zeros – Eliminates unnecessary leading zeros in numbers
- Remove Vowels – Deletes all vowels from text
- Extract Email Domain – Separates usernames and domains from email addresses into different columns