Forum Discussion
ajmal_pottekattil_yoousuf
Apr 04, 2023Iron Contributor
How to remove the special Characters from the Excel List
Here the attached file so many special characters I wanted to remove the special character and blank is needed.
NikolinoDE
Apr 04, 2023Gold Contributor
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!
I know I don't know anything (Socrates)