"CLR" wrote...
....
In C1 put........ =MID(A1,1,FIND(" ",A1,1))

This includes the space after the first name.

In D1 put.........=MID(A1,FIND(" ",A1,1),99)

This includes the space just before the last name.

In E1 put.........=MID(B1,1,FIND(" ",B1,1))

Same comment as for C1.

In F1 put.........=MID(B1,FIND(" ",B1,FIND(" ",B1,1)),LEN(B1)-6-5)

FIND(" ",B1,FIND(" ",B1,1)) always returns the position of the *first* space
in B1. Use FIND(" ",B1,FIND(" ",B1)+1). The 3rd argument to FIND is begin
search at rather than after.