Thread: Find in a string
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
  
Posts: 921
Default Find in a string
Try using the Instr & Chr Functions like this

If InStr(1, sUpcDescription, Chr(62), vbBinaryCompare) Then
sUpcDescription = Replace(sUpcDescription, Chr(62), "", 1, 1)

"Mike" wrote:

Im tring to replace with ""
sUpcDescription = sUpcDescription.Replace("", "")
But for some reason its not reconizing "". Is there a char for this symbol.
Reply With QuoteReply With Quote