remove a specific string from a string salesforce formula
Right(Left(Name,Find(" for Partner", Name)),
Len(Left(Name,Find(" for Partner", Name)))-
Find("Product",Left(Name,Find(" for Partner", Name)))+1)
& " " &
Right(Name,Len(Name)-(Find(" for Partner", Name)+12))