Find and remove data inconsistencies
1. Click on the Data menu.
2. From the Data Cleaning option, select Fix Data Inconsistencies from the drop down.
3. In the data cleaning panel, choose a column from which you want the tool to pick the inconsistencies from.
4. The tool will list down capitalization errors, typos and inconsistent spellings in the column. Eg: Laptop, laptop, Lap top
5. You can choose to replace two or more iterations of the same word or entry into one, by keying in one single format to be applied across the word cluster.
Related Articles
Remove data duplicates
1. Select the range of cells from which you want to detect the duplicates 2. Click the Data menu. 3. From the menu, select Data Cleaning . 4. Click on Find Duplicates 5. The Data cleaning tool will let you know the number of duplicate and unique ...
Find and replace data
1. Click on the Search bar on the right top corner. 2. Click on the drop down menu in the search bar, and from there choose More options. 3. Once this done, a Find and replace dialogue box will appear. 4. In the dialogue box, key in the word you are ...
How to find and remove duplicate records in my Form
It is possible to find the duplicate entries in the database and delete them. Below is the example of removing duplicate email entries in your database. You can replace the Email field with the field name that you want to find for duplicate entries. ...
Import Data
Importing records into your Recruit account can help you create new candidates from data gathered through various sources, such as a purchased record database or records from different business units. You can import records using two features: Import ...
How do I remove sample data from Zoho CRM?
To remove sample data from your CRM account, do the following: Go to Setup > Data Administration > Remove Sample Data. Click Yes, Proceed. The sample data removal process will be scheduled. You will be notified once the sample data has been ...