Remove value from string

[aaronk]

Hello,

I am trying to remove a ' from my string but not sure on how to do it.

So far I am able to detect if my string contains what I am looking for but not sure how to remove it from my string.

For Example:

Dim MyString as String
MyString = "123'abc"
If MyString.Contains("'") Then
' now want it to return "123abc" without the ' in the string
End If

Does anyone know how to remove something from a string?

 

[NJDude]

Dim MyString as String
MyString = "123'abc"

MyString = MyString.Replace("'", "")

 

[aaronk]

Hello,

Thank heaps, I knew it would be simple but just couldn't think of how to do it.