Using Formulas to Generate SKU codes

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!

Greetings
It is fairly complicated and messy to have 1 formula, especially given the variable length of the values in each column. I suggest you remove the restriction to have the answer in formula and open it up for VBA solutions as well. You will find solutions coming in thereafter.

Regards