What is function to Remove duplicating text from 2 different Cells

[manoi]

What is the command/function that could match "All" of the text in cell A (in Specific Order) to "Some" of the text in Cell B and delete the duplicate text phrases that appear in "B"?


Example
A-------------------------B--------------------------------------------C
the quick brown fox------The quick brown fox jumped over lazy dog----over lazy dog
red fox------------------ Red Fox jumped over lazy dog---------------over lazy dog
Gray & Brown Fox ------- Grey & Brown Fox over lazy dog -------------over lazy dog
Blue & Red Fox 23 ------- The Blue & Red Fox is over lazy dog--------- The over lazy dog
Green & Brown Fox 45-----The Green & Brown Fox 45 over lazy dog---- The over lazy dog

Desired results is C === a-b=c

[Mallycat]

You need to use a composite formula. Use =search() to "find" if the data exists. if it does, it will return the location. You can then use =mid() to extract the data.