Subtracting Word From Line

I know you can add things to a line by going + "whatever", but I wanted to know how to minus a word from a line. Lets say the line was '(Enter)> Cow' and I want to subtract the (Enter)> from the line. How would I do that? I've tried the '-' sign but I always get an error.


Thanks. :)

Dim x As String
x = "(Enter)> Cow"
Dim y
y = Split(x, " ")
x = y(UBound(y))
MsgBox x

You could use the Mid or Right functions as well to subtract words from the right (Left or Mid function to subtract words from the left).

Code:

---

x = "(Enter)> Cow"
MsgBox Right$(x, 3)
MsgBox Mid$(x, InStr(x, ">") + 2)

---

And, if your VB version is 6.0 or later, you can use Replace :D

TheText = Replace(TheText, "Word-You-Wanna-Remove", "") 'Replace what you don't want with nothing :)