Formula to extract first name and last name

[Thembela01]

I have searched everywhere . My formula doesnt work

John F Kennedy - JohnF
Ben Mango-BenM
Siya Ginger Kolisi - SiyaK

I want to combine the first name plus the last initial. It must ignore the middle name

 

[GlennUK]

What about people with multipart surnames, like Van Deeson, or with ordinals after name like John Brown III, or with Jr or Sr after name. There are so many variations and permutations of how a name may exist, I doubt you will get a formula to do what you want and cope with such possibilities.

 

[Thembela01]

But those are not that many, i can handle them manually

 

[GlennUK]

Then use this formula:
=LEFT(A2,FIND(" ",A2)-1)&LEFT(TRIM(RIGHT(SUBSTITUTE(TRIM(A2)," ",REPT(" ",100)),100)),1)

 

[Thembela01]

Thanks so much. It worked