Clean Excel Data

Hi All,   I have data in excel Column which looks good but when i match that with a different excel with exactly same data it doesn't match. When i paste the data in notepad i observe that the da...