Extract text from a string minus a word in another cell and not extracting the -

[jdhfch]

Hi,

Please can someone help?

I am trying to extract all the text from a cell minus a word in another cell and minus any -. For example

:Example string	Extract text from a string minus a word in another cell and not extracting the -
Words to exclude:	Extract text
Result required:	from a string minus a word in another cell and not extracting the

 

[diddi]

try this
Source is in A1, excluded text is in B1

=SUBSTITUTE(SUBSTITUTE(A1, B1, ""),"-","")

 

[jdhfch]

Excellent.. Thank you