| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find in a string
Im tring to replace with ""
sUpcDescription = sUpcDescription.Replace("", "") But for some reason its not reconizing "". Is there a char for this symbol. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find in a string
Try
Supcdescription = Replace(Supcdescription, "", "") -- Trev B "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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find String in another string - only between spaces | Excel Worksheet Functions | |||
| Find Many String options in ONE String | Excel Worksheet Functions | |||
| search a string withing a string : find / search hangs | Excel Programming | |||
| backwards find function to find character in a string of text | Excel Programming | |||
| find a string inside another string | Excel Programming | |||
Linear Mode
