Separating First & Last Names

Try this
Enter formula in B2 and drag formula across to D2 and down

Formula:

=TRIM(MID(SUBSTITUTE(" "&IF(ISERR(FIND(" ",$A2,FIND(" ",$A2)+1)),SUBSTITUTE($A2," ",REPT(" ",2)),$A2)," ",REPT(" ",50)),50*COLUMNS($A:A),50))

v	A	B	C	D
1	Names	F. Name	M. Name	L. Name
2	John B Doe	John	B	Doe
3	John Doe	John		Doe
4	Richard Jay Flint	Richard	Jay	Flint
5	George T Clooney	George	T	Clooney
6	Larry Bird	Larry		Bird