Excel How to Clean Data
“Data Cleaning” utilities »
In the Excel menu choose: D-PRO » Data Cleaning » Data Cleaning
Trim spaces and non-printing characters.
Change characters case to.
Text to numbers.
Numbers to text.
1. Trim spaces and non-printing charcters
Trim spaces at the beginning/end of text
Remove all excess spaces
Remove line breaks in cells
Remove non-printing characters
2. Change characters case to
3. Text to numbers
converts a cell with numbers formatted as text to numbers.
4. Numbers to text
Converts the numeric cells in text format by adding an apostrophe
Copyright © 2014 - 2018 Zbrainsoft.com | All Rights Reserved. Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Dose For Excel
Free trial 14 days (with full functionality)