How to subtract a cell in Excel?

Question

excel

Hello.
Say there is a column A that contains the names of goods in which there is an article and there is a column B with separate articles.
Is it possible somehow from Column A - Column B = and the output should be column D "Product name without article number"
I would do it manually, but I don’t really want 10k rows)

Answer 1

В ячейку D:
=ЗАМЕНИТЬ(A1;НАЙТИ(B1;A1);ДЛСТР(B1);"")