Hi Guys,
I'm looking for a formula that generates SKU codes.
The idea is that the formula would use the first letter of every word in a cell to create the letters/numbers of the code. See attached excel for an idea of what I'm looking for.
Column A
XV
Column B
6 Months
Column C
Ewan Donnachie And Lucas Vazquez
Column D (Formula)
XV-6M-EDALV
Can this be done? It would be of immeasurable help!
Thank you for your time!
Bookmarks