Excel How to Clean Data

“Data Cleaning” utilities » Data Cleaning
In the Excel menu choose: D-PRO  » Data Cleaning » Data Cleaning

  • Trim spaces and non-printing characters

  • Trim spaces at the beginning/end of text
  • Remove all excess spaces
  • Remove line breaks in cells
  • Remove non-printing characters
  • Change characters case to

  • Proper Case
  • Sentence case
  • lower case
  • Text to numbers

converts a cell with numbers formatted as text to numbers.
  • Numbers to text

Converts the numeric cells in text format by adding an apostrophe
Excel upper case
Excel lower case
Excel lower case
Excel lower case
Excel proper case
Excel capitalize
Excel leading spaces
Excel leading spaces
Excel text to numbers
Excel text to numbers
Excel numbers to text
Excel numbers to text

HOME           PRODUCTS           EULA           AFFILIATES           SUPPORT           ABOUT US
Excel Data Cleaning
Dose For Excel
Free trial 14 days (with full functionality)

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.