Split Combined Name

  • Thread starter Thread starter dlaw
  • Start date Start date
D

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.
 
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.
Click to expand...

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)).
 
Back
Top