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)="...