Middle name + 1st name

Get the initial (middle name) from a triple name in a cell.
C4 The cell contains the triple name separated with spaces.
=LEFT(C4,1) & "." & MID(C4, SEARCH(" ", C4, 1) + 1, 1) & "." & MID(C4, SEARCH(" ", C4, SEARCH(" ", C4, 1) + 1) + 1, 1) & "."

Get the 1st name from a cell containing a string separated with spaces.
F13 Cell containing the long string.
=LEFT(F13,SEARCH(" ",F13,1)-1)

Tags:,