Dim text As Variant
Dim newtext As Variant
Dim finda(4) As Variant
Dim replacea As Variant
text= Ucase("192.168.36.191 abcd")
finda(0) = "A"
finda(1) = "B"
finda(2) = "C"
finda(3) = "D"
finda(4)= " "
replacea=""
newtext= Replace(text,finda,replacea)