locked
Find and replace a non-ASCII character RRS feed

  • Question

  • I want to find Ŋ and ŋ characters in my Excel document and replace them with their respective codes Ŋ and ŋ

    Ŋ and ŋ are outside ASCII.

    What is the syntax for a find and replace like that?

     


    Saturday, June 17, 2017 4:21 AM

Answers

  • Sub Test()
      Dim i As Integer
      For i = 330 To 331
        Cells.Replace ChrW(i), "&#" & i, xlPart
      Next
    End Sub

    • Marked as answer by AfricaJohn Sunday, June 18, 2017 5:32 AM
    • Unmarked as answer by AfricaJohn Sunday, June 18, 2017 2:19 PM
    • Marked as answer by AfricaJohn Sunday, June 18, 2017 2:42 PM
    Saturday, June 17, 2017 8:40 AM