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))