How to Remove ALL SYMBOL IN SENTENCE VIA FORMULA IN EXCEL

[krunal123]

I Don't Not this formula .................................................................

 

[Yongle]

You can use User Defined Function below as a formula in your worksheet
=AlphaNumeric(A1)

Place code in a module like Module1

Function AlphaNumeric(s As String) As String
    Dim c As Variant
    Dim x() As Byte
    x = s
    For Each c In x
        If Chr(c) Like "[A-Z a-z 0-9]" Then AlphaNumeric = AlphaNumeric & Chr(c)
    Next c
End Function