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



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.



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.



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.



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.



More Features:
Excel Select Used Range
Select Used Range With One Click Most annoying thing is when you want to select…
How to Select Interval Rows or Columns in Excel
Select Interval Rows Or Columns In Excel Easily select interval rows or columns, for example,…
Excel Remove Or Replace Comments
Advanced Comments Assistant For Excel If you ever want to remove comments or replace them…
Excel Insert Title Rows
Insert Title Rows In Your Excel Range Sometime you may need to add a title…
Excel Filter By Selected Value
Excel Fast Filter To not wasting time by navigating to Data tab and click on…
Dose for Excel Languages
Dose for Excel Multi-Language Dose for Excel Add-In supports many languages, you can change the…