View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Find in a string

Sub test()
Dim s1 As String, s2 As String
s1 = "ABC"
s2 = Replace(s1, "", "")

MsgBox s1 & vbCr & s2
End Sub

Regards,
Peter T

"Mike" wrote in message
...
Im tring to replace with ""
sUpcDescription = sUpcDescription.Replace("", "")
But for some reason its not reconizing "". Is there a char for this
symbol.