I have 2 columns. Column A has product name, Column B in some cases has product name + description. I want to strip out the product name in Column B if it exists, and then in a second operations put it back.

Example.

--------------------------------------------------------After Removed------------------END RESULTS
Column A---------------Column B-------------------------------Column C-------------------------------COLUMN D

Brown Fox--------The best of the best.-----------------------The best of the best.------------Brown Fox The best of the best.
Red Fox----------Red Fox is the best of the best.------------- is the best of the best.----------Red Fox is the best of the best.
Gray Fox 33------Grey Fox is the best of the best--------------is the best of the best----------Gray Fox 33 is the best of the best
Black Fox 22------Black Fox 22 is the best of the best.---------is the best of the best.----------Black Fox 22 is the best of the best.



*** COLUMN D IS DESIRED RESULTS -- NOTE HOW END RESULT = A+C=D

what are the function(S) to perform this?