I ahve a string "10.25 POLYSTER FILM 10.25x0 11gsm 12mic" I have to remove string that has "x" in the middle of it. Either side of this character there are numbers, and has decimal also there i have to remove it
What I have tried:
For g = 1 To VS_Paper_Grid_1.Rows - 1
lLastSlash = InStr(1, VS_Paper_Grid_1.TextMatrix(g, 0), "x")
If lLastSlash > 0 Then
Paper_Name = Left$(VS_Paper_Grid_1.TextMatrix(g, 0), 2)
Paper_Name = Right$(VS_Paper_Grid_1.TextMatrix(g, 0), 2)
VS_Paper_Grid_1.TextMatrix(g, 0) = Paper_Name
lLastSlash1 = InStr(1, Paper_Name, "/")
Paper_Name = Left$(lLastSlash1, lLastSlash - 1)
End If
Next