Clean Data In Excel
Clean data in huge Excel sheets could take long time doing it manually, such like trim spaces, changing letters case, converting text to number or vice versa. Dose for Excel’s Data Cleaning utility can clean data with one click on huge worksheets.
Click DOSE » Data Cleaning
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-data-cleaning.png)
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-data-cleaning-pane.png)
Trim spaces and non-printing characters
- Select range of cells to merge and check Trim spaces and non-printing characters option.
- Check one of the below 4 options:
- a. Trim spaces at the beginning/end of text.
- b. Remove all excess spaces.
- c. Remove line breaks in cells.
- d. Remove non-printing characters.
- Then click Apply. You will see the result as shown in the below screenshot.
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-data-cleaning-trim-test.png)
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-data-cleaning-trim-result.png)
Change characters case to
- Select range of cells to change their letters case and check Change characters case to option.
- Check one of the below 4 options:
- a. Proper Case.
- b. Sentence case.
- c. lower case.
- d. UPPER CASE.
- Then click Apply. In below example, we changed the characters case into UPPERCASE You will see the result as shown in the below screenshot.
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-data-cleaning-change-case-test.png)
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-data-cleaning-change-case-result.png)
Text to numbers
- Select range of cells to convert them from text to numbers and check Text to numbers option.
- Then click Apply. You will see the result as shown in the below screenshot.
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-data-cleaning-text-to-numbers-test.png)
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-data-cleaning-text-to-numbers-result.png)
Numbers to text
- Select range of cells to convert them from text to numbers and check Numbers to text option.
- Then click Apply. You will see the result as shown in the below screenshot.
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-data-cleaning-numbers-to-text-test.png)
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Data Cleaning](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-data-cleaning-numbers-to-text-result.png)
More Features:
Excel Random Generator
Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…
Excel Formula Helper
Use Built-In Advanced Formulas In Excel You can quickly use built-in formulas without writing them…
Excel Delete Blank Sheets
Delete All Empty Worksheets Excel Delete all blank or empty sheets in Excel one time…
Excel Insert Before After
Insert Text Before Or After In Excel Cells You can add text before first letter…
How To Color Alternate Row In Excel
Color alternate row or column in Excel With this utility you can quickly apply shading…
Excel Delete Rows
Excel Highlight Or Delete Any Type Of Rows Highlight or delete items that are identical,…