vba remove character from string

The solution for “vba remove character from string” can be found here. The following code will assist you in solving the problem.

Sub remove_case_sensitive_char()
Dim var As String
Dim output As String
var = “The Winner is AUSTRALlIA”
‘to remove all occurrences of “l” from input string (var)
output = Replace(var, “l”, “”)
MsgBox output
End Sub

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts