Modify Formula to Create Acronyms; Not Reference First 3 Characters

[luxehouseofcouture]

Hello,

Someone from this forum helped me create the below formula to automate and standardize the process of creating unique SKU's for my Shopify products:

=UPPER(CONCATENATE(LEFT(CONCAT(LEFT(D2,1),IF(ISERROR(FIND(" ",D2)),MID(D2,2,3),MID(D2,SMALL(IF(MID(D2,ROW(INDIRECT("A1:A"&LEN(D2))),1)=" ",ROW(INDIRECT("A1:A"&LEN(D2)))+1),ROW(INDIRECT("A1:A"&LEN(D2)-LEN(SUBSTITUTE(D2," ",""))))),1))),4),"-",LEFT(SUBSTITUTE(CONCAT(LEFT(B2,1),MID(B2,SMALL(IF(MID(B2,ROW(INDIRECT("A1:A"&LEN(B2))),1)=" ",ROW(INDIRECT("A1:A"&LEN(B2)))+1),ROW(INDIRECT("A1:A"&LEN(B2)-LEN(SUBSTITUTE(B2," ",""))))),1)),"&",""),4),"-",IF(ISERROR(FIND("/",I2)),LEFT(I2,3),CONCAT(IF(NOT(ISERROR(FIND(" ",I2))),LEFT(I2,1),LEFT(I2,1)),IFERROR(MID(I2,FIND(" ",I2)+1,1),""),MID(I2,SMALL(IF(MID(I2,ROW(INDIRECT("A1:A"&LEN(I2))),1)="/",ROW(INDIRECT("A1:A"&LEN(I2)))+1),ROW(INDIRECT("A1:A"&LEN(I2)-LEN(SUBSTITUTE(I2,"/",""))))),1))),"-",INDEX(Codes!$M:$M,MATCH(K2,Codes!$L:$L,0))))

You can read the original thread here.

There's just one problem, which when solved, will help ensure the formula is creating less duplicate values. When there is one color with multiple words (i.e. Light Teal Blue), the formula is currently converting it to LIG, which is just referencing the first three characters of the value in the cell. I would rather it convert to LTB instead, which is an acronym of the cell in the value. What would I have to adjust to make this happen?

Any assistance you can provide would be greatly appreciated. I'm under a strict deadline here.

 

[KurtC_excel]

I am very curious about whether or not the excel spreadsheet that was referenced in the original post, as I cannot seem to click to see the original worksheet and even placing the formula in a blank worksheet, the formula is not working for me... Please help.