Removing weird/garbage text from Excel

[desibouy]

Hi,
So before posting I have tried searching online and searching here, whilst I did get it resolved I've found another issue.

So my Excel files have these –, ¿½, â„¢ & ÔÇô etc. So as I said checking online it's to do with encoding, I re-saved the file as ANSI in notepad which got rid of these weird characters.
Now I'm getting "???", sometimes with a space in front " ???" or "??" Now I don't know how to get rid of these.

So my question is

1. Is there any way to quick fix these? I'll stick to the weird symbols rather than question marks. I have over 5000 Product Description. Can't tell how many I need to fix here and what to use i.e. Quote Marks, Single Apostrophe, Commas, Hyphens or something else.

2. How can I prevent this from happening? I work with a LOT of Products and I had this a lot but I've just fixed when I came across it. Same thing with UPC Codes where they auto change to like "759393994672" to "750000000002".

Any help appreciated.

Thanks

 

[desibouy]

Sub Is_This_A_Start()
Dim arr, i As Long
arr = Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row).Value
    For i = LBound(arr) To UBound(arr)
        arr(i, 1) = Replace(Replace(arr(i, 1), "’s", ","), "≥", ChrW(8804))
    Next i
Sheets("Sheet2").Range("A1").Resize(UBound(arr)) = arr
End Sub

Hello,

I'm guessing I can add more stuff in here? "’s", ","), "≥", ChrW(8804))
I'll give it a go.

Thanks.