title: Replace weird or special character in a string
body: <p>I'm trying to convert a Excel file into a SQL query. My problem is that there are special characters in the file I was given. I cant replace them CTRL+H because they dont show at all in the Excel file. When I write my query(either in utf8 or ANSI), they show. With Ultra-Edit, they show as HEX C2 92. With Notepad++ in utf8, they show as PU2. In ANSI, they show as Â’. I suspect it's an apostrophe. This is a french file by the way.</p>
  
  <p>So far I tried to put it in a string and do these operations, but nothing worked.</p>
  
  <pre><code>Dim Line as String
  
  Line = Wb.Worksheets(1).Cells(LineNo, ColNo)
  
  Line = Replace(Line, "Â’", "''")
  Line = Replace(Line, "’", "''")
  Line = Replace(Line, "Â", "''")
  Line = Replace(Line, Chr(194) &amp; Chr(146), "''") 'decimal value of C2 92
  Line = Replace(Line, Chr(146) &amp; Chr(194), "''") 'inverted decimal value of C2 92
  </code></pre>
  
  <p>Thanks!</p>