Split Combined Name

[dlaw]

Cell A contains a name in the format 'first initial last'.
I want to create cells from this: 'first' 'initial'
and 'last'.

Are there formulas for the 3 cells that will accomplish
this?

Thanks for the help.

 

[mr]

Cell A contains a name in the format 'first initial last'.
I want to create cells from this: 'first' 'initial'
and 'last'.

Are there formulas for the 3 cells that will accomplish
this?

Thanks for the help.

Try:
Cell A1 contains a name - John Smith.
The formula for extracting the first name is =LEFT(A1,FIND(" ",A1)).
The formula for extracting the last name is =MID(A1,FIND("
",A1)+1,LEN(A1)).