XLTools.net Data Cleaning

After you paste or import external data to Excel, you may need to clean the data from redundant spaces, line breaks or non-printing symbols. If you work with bulk data, manual cell-by-cell changes take long painstaking hours. Data Cleaning App by XLTools will prepare your data in just a few clicks:

• Trim spaces in the beginning and the end of text

• Remove all excess spaces

• Remove line breaks in cells

• Remove non-printing characters

• Change text case to Proper Case, Sentence case, lower case or UPPER CASE

• Convert text to numbers, i.e. values stored as text to number format

• Convert numbers to text, i.e. values stored as numbers to text format

Please note: the operation cannot be undone. Any formulas will be overwritten with values.