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

  1. Trim spaces and non-printing charcters.
  2. Change characters case to.
  3. Text to numbers.
  4. Numbers to text.




 
1. Trim spaces and non-printing charcters

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

  • Proper Case
  • Sentence case
  • lower case
  • UPPER CASE
 
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
 
Excel upper case
Up
Up
Up
Up
Excel lower case
Excel lower case
Excel lower case
Excel proper case
Excel capitalize
Excel Data Cleaning
Excel leading spaces
Excel leading spaces
Excel text to numbers
Excel text to numbers
Excel numbers to text
Excel numbers to text
Home

Copyright © 2014 - 2017 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.
Home