How to get rid of all special characters using vba

Question

My data contains #, / , ' etc. How can I get rid of all those things and substitute them with "" . I want to apply this to Sheet1 all cells ?

Answer 1

Sub RemoveSpecChars()
    Dim Token As Variant
    For Each Token In Array("-", "\", "#")  'etc.
        Sheet1.UsedRange.Replace Token, ""
    Next Token
End Sub