In my case, what I'm trying to do is clear the product numbers from product names.

Clearcontent.PNG

Basically put, all the content existing in A2 should be cleared in B2, and the result should be: "Braun World Time Clock"