I have sheet1 which contains SKU's in 'Column A' and Description in 'Column B'
Is it possible for a description to be entered, and parse the SKUs of each description into one long 'smart code' or 'smart SKU' ?
For example:
Description
User input 'Base Double Door Cabinet 30" with Half Depth Shelf Avenue Cherry Arch Cider'
Generated Smart Code
Output: B30HDS.AVECHS.CDNON
Bookmarks