Скачать или смотреть 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