Sorry, this will be an easy answer for some, but I'm still learning.
I need to check if a string variable ends with "s", and if it does, remove the "s". I have the check working with EndsWith, but not the replacement.
Tried this:
Dim MyString As String
MyString = "Apples"
If MyString.EndsWith("s") Then
MyString = MyString.SubString2(0, MyString.Length -1)
End If
Msgbox(MyString, "")