Delete String if in other Textbox

[djblois1]

Say I have 2 textboxes called textboxA and TextboxB. TextboxA will have a long string and TextboxB will have a small string. If I find TextboxB in TextboxA's String - then I want to remove that piece from TextboxA. Is this possible? here is an example:

TextboxA: Tuna, Tongol 4/3 lb
TextboxB: 4/3 lb

I want to remove what is in TextboxB from TextboxA so I would get this:

TextboxA: Tuna, Tongol
TextboxB: 4/3 lb

the string that needs to be removed from TextboxA will not always be at the end of it and will not always contain numbers. Sometimes it will be all letters sometimes letters and numbers, etc.

[JBeaucaire]

You can use the REPLACE function to do that. Read up on the function, then play around with it, something like:

If InStr(TextBoxA.Value, TextBoxB.Value) > 0 Then
    TextBoxA.Value = Trim(Replace(TextBoxA.Value, TextBoxB.Value, ""))
End If