Title: Data Cleanup Tips for Microsoft Excel - Office Articles
Headings: Data Cleanup Tips for Microsoft Excel
Data Cleanup Tips for Microsoft Excel
Data Isn't Recognized Properly
Clean Up Extra Spaces or Characters Using Find and Replace
Use the TRIM Function to Remove Spaces
Use the CLEAN Function to Remove Non-Printing Characters
Vertical to Horizontal Addresses
Sorting as a Data Cleanup Tool

Content: Find what: Type a left parenthesis (or a right parenthesis or a hyphen or a period)
Replace with: Leave this empty! Replace all
Use the TRIM Function to Remove Spaces
The TRIM function removes spaces to the left and right of your data, but not spaces between data within a single cell. Insert a blank column to the right of the column you want to trim. For our purposes, we'll use column A as the column we want to trim, and B2 is where we'll put our first formula. =TRIM (A2)
Copy the formula down using the fill handle. In order to work with the trimmed text, highlight the cells, hit Edit Copy, then hit Edit Paste Special, Values, OK. That removes the underlying formulas. You can now move your column heading over to your new column of trimmed data, and delete the original column.