Johnny

Formulas is not my stong point so someone else may offer a better solution

Assuming name is in A3

=LEFT(A3,1)&MID(A3,FIND(" ",A3,1)+1,1)&MID(A3,FIND(" ",A3,FIND(" ",A3,1)+1)+1,LEN(A3))

__________________
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely

Top Excel links for beginners to Experts

If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.