Create Acronym from Phrases or Extract First Three Characters from One Word

This thread is cross-posted

I am in the process of creating a SKU generator for my Shopify products. I want the logic for the SKU's to follow the below template.

Example Product 1:

• Vendor: Zutter
• Name: Shirley Brushed Waffle Tunic
• Color: Light Blue/Red/White
• Size: X Large

Example SKU 1:

• ZUTT-SBWT-LBRW-XL

Example Product 2:

• Vendor: Love Tree
• Name: Transition Cardigan
• Color: Light Blue
• Size: Small

Example SKU 2:

• LT-TC-LB-S

Things to Note:

• Ideally, I would like to have the formulas reference the Codes tab and use the respective ID value for the adjacent matching value within the generated SKU's (i.e. the code for Booties is Btie).
• Product names variables should be generated as acronyms (i.e. Shirley Brushed Waffle Tunic would output as SSBW)
• Characters for each product variable should max at 4, using the first words in the text string to generate the variable acronym (i.e. Shirley Striped & Brushed Waffle Tunic would output as SSBW)
• In the event of a duplicate SKU, a numerical identifier should be appended to the duplicate (i.e. LT-TC-LB-S and LT-TC-LB-S-1)
• I have too many colors in my shop to create ID codes. So, we'll just need to generate an acronym to accomplish this. if a color is a phrase (i.e. Light Blue), the acronym would be LB. But if it is a multi-color option, the acronym should encompass all color options (i.e. Light Blue/Red/Green would be LBRG). I'd imagine that the formula needs to have an OR condition that looks for " " or "/" as a possible separator in order to accomplish this.
• Variables can be alpha-numerical and must be separated by hypen's (-).

Welcome to the Forum incrediblehabits!

As a new member, please take the time to review our rules. There aren't many, and they are all important.

Rule #3 requires you to post a link if you post the same question on another site. Please edit your first post (or add a new post) to include a link to the URL on Mr. Excel where you have posted the same question. Read this to understand why we ask you to do this. (Mr. Excel has the same rule.)

This thread should receive no further responses until cross-post links are provided

Moderator added link to post #1 for new member