AN UNBIASED VIEW OF EXCEL DATA CLEANING

Enter the =TRIM command from the column beside the a person you wish to clean. So to scrub column A, in cell B2 enter =TRIM(A2) for the initial mobile beneath the header. Then duplicate and paste the B2 formula down the column to course of action each of the other rows of messy data. As often, copy the formula in the initial mobile of each column