How to remove unwanted cell characters in excel

Описание: This video show, how to remove unwanted special characters from your Excel cells, and you don't need more time to do it manually, using simple VBA code can do it.

🧑‍💻 Source Code
----------------------------------------------------------
Function ExtractName(ByVal inputStr As String) As String
Dim resultStr As String
Dim i As Long
Dim char As String

resultStr = ""

For i = 1 To Len(inputStr)
char = Mid(inputStr, i, 1)

If UCase(char) Like "[A-Z ]" Then
resultStr = resultStr & char
End If
Next i

ExtractName = resultStr
End Function
----------------------------------------------------------

#thetutorbuddy #excel #tricks