How to remove the special Characters from the Excel List

ajmal_pottekattil_yoousuf 

You probably mean convert and not remove, otherwise the Del key would be too simple 🙂 …if so here's a workaround.

You can convert characters created with the keyboard like “#$#$%$%” to numbers by following a simple pattern; a = 1, b = 2, c = 3, etc

Here’s a VBA code that you can use to convert characters created with the keyboard like “#$#$%$%” to numbers with step by step instructions:

Sub ConvertCharactersToNumbers()
    Dim str As String
    Dim i As Integer
    Dim result As String
    
    str = "#$#$%$%"
    
    For i = 1 To Len(str)
        result = result & Asc(Mid(str, i, 1)) - 64
    Next i
    
    MsgBox result
End Sub

This code will convert “#$#$%$%” to “19201920”.

I hope that helps!

NikolinoDE

I know I don't know anything (Socrates)

ajmal_pottekattil_yoousuf 

Do you want to remove the special characters from column D (serial_no)?