Clean data in Excel: trim extra spaces or line breaks, change text case, convert text to numbers
This brief overview of the XLTools Data Cleaning add-in shows:
How to easily clean large ranges in Excel
How to trim leading, trailing or redundant spaces, unwanted line breaks or non-printing characters in cells
How to change text case in cells
How to convert cell format from numbers to text, or from text to numbers
Download at https://xltools.net/download/
Suitable for Microsoft Excel 2016, 2013, 2010, 2007, and desktop version of Office 365 (32-bit and 64-bit).
