Clean Excel Data

[VBA_ENTHU1988]

Hi All,

1. 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.
2. When i paste the data in notepad i observe that the data in excel which looks clean in excel it has "" and extra line. s per below screenshot
3. In excel it looks as 
4. when Column D data is pasted in Notepad it looks as 
5. Kindly help me clean data of Colum D from "Acc/CR/1142172919/pj/okax/ns094
   "
   to Acc/CR/1142172919/pj/okax/ns094.
6. I need to remove double quotes at start and end and an extra line

[#2]

Find and replace perhaps? (The looking glass icon on your Excel ribbon's Home tab, on the far right)