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!