Here is the formula I'm using:
="Women's Handmade "&D2&" Adjustable Stackable Statement Bracelet "&IF(AND(E2<>"",ISBLANK(F2))," with a "&PROPER(E2)&" Charm",IF(AND(ISBLANK(E2),F2<>"")," with a "&PROPER(F2)&" Connector",IF(AND(ISBLANK(F2),ISBLANK(E2)),"",IF(E2<>""&F2<>""," with a "&PROPER(E2)&" Charm and a "&PROPER(F2)&" Connector",""))))
[TABLE="width: 1202"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]InventoryNr[/TD]
[TD]Color[/TD]
[TD]Charm[/TD]
[TD]Connector[/TD]
[TD]Title/Descripton[/TD]
[/TR]
[TR]
[TD]ADJ1[/TD]
[TD]Silver[/TD]
[TD][/TD]
[TD]Leaf[/TD]
[TD]Women's Handmade Silver Adjustable Stackable Statement Bracelet with a Leaf Connector[/TD]
[/TR]
[TR]
[TD]ADJ3[/TD]
[TD]Black & Blue[/TD]
[TD]Handcuffs[/TD]
[TD][/TD]
[TD]Women's Handmade Black & Blue Adjustable Stackable Statement Bracelet with a Handcuffs Charm[/TD]
[/TR]
[TR]
[TD]ADJ4[/TD]
[TD]White, Blue, Red & Silver[/TD]
[TD][/TD]
[TD][/TD]
[TD]Women's Handmade White, Blue, Red & Silver Adjustable Stackable Statement Bracelet [/TD]
[/TR]
[TR]
[TD]ADJ5[/TD]
[TD]Blue & Black[/TD]
[TD]Handcuffs[/TD]
[TD][/TD]
[TD]Women's Handmade Blue & Black Adjustable Stackable Statement Bracelet with a Handcuffs Charm[/TD]
[/TR]
[TR]
[TD]ADJ6[/TD]
[TD]Silver[/TD]
[TD]round "breathe"[/TD]
[TD]filigree[/TD]
[TD]Women's Handmade Silver Adjustable Stackable Statement Bracelet with a Round "Breathe" Charm and a Filigree Connector[/TD]
[/TR]
[TR]
[TD]ADJ7[/TD]
[TD]Silver[/TD]
[TD][/TD]
[TD]skull[/TD]
[TD]Women's Handmade Silver Adjustable Stackable Statement Bracelet with a Skull Connector[/TD]
[/TR]
[TR]
[TD]ADJ8[/TD]
[TD]Aqua[/TD]
[TD] "Best Friends" Set[/TD]
[TD][/TD]
[TD]Women's Handmade Aqua Adjustable Stackable Statement Bracelet with a "Best Friends" Set Charm[/TD]
[/TR]
[TR]
[TD]ADJ9[/TD]
[TD]Silver[/TD]
[TD]Tiny Heart[/TD]
[TD][/TD]
[TD]Women's Handmade Silver Adjustable Stackable Statement Bracelet with a Tiny Heart Charm[/TD]
[/TR]
[TR]
[TD]ANK2136[/TD]
[TD]Coral[/TD]
[TD][/TD]
[TD][/TD]
[TD]Women's Handmade Coral Beaded Anklet[/TD]
[/TR]
[TR]
[TD]ANK2137[/TD]
[TD]Black[/TD]
[TD][/TD]
[TD][/TD]
[TD]Women's Handmade Black Beaded Anklet[/TD]
[/TR]
[TR]
[TD]ANK2138[/TD]
[TD]Blue[/TD]
[TD][/TD]
[TD][/TD]
[TD]Women's Handmade Blue Beaded Anklet
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"]Color[/TD]
[TD="width: 64"]Charm[/TD]
[TD="width: 64"]Connector[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Black[/TD]
[TD]Panda[/TD]
[TD]Love[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl66"]Type[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]ADJ[/TD]
[TD="colspan: 3"]Women's Handmade Love Adjustable Stackable Statement Bracelet [/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]ANK[/TD]
[TD="colspan: 3"]Dunglebees Women's Handmade Beaded Anklet a Panda Charm and a Love Connector[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]APB[/TD]
[TD="colspan: 3"]Dunglebees Women's Handmade Anglican Prayer Beads Episcopal Rosary a Panda Charm and a Love Connector[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]BAE[/TD]
[TD="colspan: 3"]Dunglebees Women's Handmade Beaded Bracelet & Earring Set a Panda Charm and a Love Connector[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]BKM[/TD]
[TD="colspan: 3"]Dunglebees Women's Handmade Beaded Bookmark a Panda Charm and a Love Connector[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]BRC[/TD]
[TD="colspan: 3"]Dunglebees Women's Handmade Black Beaded Stackable Statement Bracelet with a Panda Charm and a Love Connector[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]CAR[/TD]
[TD="colspan: 3"]Dunglebees Women's Handmade Beaded Car Charm, Rearview Mirror Hangler, Car Accessory a Panda Charm and a Love Connector[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]EAR[/TD]
[TD="colspan: 3"]Dunglebees Women's Handmade Beaded Fishhook Pierced Earrings a Panda Charm and a Love Connector[/TD]
[/TR]
</tbody>[/TABLE]