vba remove character from string
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