Extract first letter of each word

[TC13]

Can anyone please help me, with what formula can I extract the first letter of each word in a range of names?
So I have a range of First, Second and third names and I would like to extract the initials to a separate cell. Some have only one name and some have 2 or 3 names. EG:

Mzolisi William
Nothemba Princess
Keith Vernon Peter
Leigh

And I want to extract the First letters so that the result would be

MW
NP
KVP
L

[XLent]

given 2019

Please Login or Register  to view this content.

[Sam Capricci]

this is one way ...
=IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=0,LEFT(A1,1),IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=1,LEFT(A1,1)&MID(A1,FIND(" ",A1)+1,1),LEFT(A1,1)&MID(A1,FIND(" ",A1)+1,1)&MID(A1,FIND(" ",A1,FIND(" ",A1)+1)+1,1)))

[TC13]

Thank you so much. Wow I did not expect the formula to be so complicated. I am still learning about formulas and will have to learn each function in this formula to be able to understand it better.

However, I just started manually typing the initials from the top of my list and Excel automatically wanted to auto fill the rest of my range. Just had to press enter and then Excel did it for me. :-)