How to remove substring from another column in Excel?

Question

excel

I want to remove some text from current column. This part of the text is presented in another column.
For clarity:

So, I want to remove the model number from the Title column.

Answer 1

You can remove the function =SUBSTITUTE(A2,B2,"").
And to remove residual spaces, you need to wrap it in TRIM.
Outcome = TRIMSPACES(SUBSTITUTE(A2;B2;"")), and this function needs to be "dragged".