Hi Jindon,

Your Function works well if the variation info is at the end of the Product name only,

Nike Shoes for Men Red Small 1
Nike Shoes for Men Green Small 1
Nike Shoes for Men Blue Small 1

Output: Nike Shoes for Men


But it fails when the variation info changes places


Nike Shoes for Men Red Small 1
Nike Shoes for Men Green Small 1
Nike Blue Shoes for Men Small 1

Output: Nike ( Where as it should be Nike Shoes for Men)

Andrews function could handle that, is there a way u can fix that?

Thanks

Alfred