extract first name only from full name

[Guest]

I have a cell that contains last name, first name. I would like to extract
the first name and put in seperate cell. As an example if A1 = Smith John I
would like to have A2 = John and A3 = Smith Please advise.

 

[Guest]

Try this:

A2 =RIGHT(A1,LEN(A1)-FIND(" ",A1))
A3 =LEFT(A1,FIND(" ",A1)-1)

 

[PCLIVE]

If there is no comma between the last and first name, then the given
formulas will work. However, if there is a comma between the names (ex.
Smith, John), then you'll need to adjust the formula slightly. In that
case, I'd prefer to find the comma and go from there.

First Name =RIGHT(A1,LEN(A1)-(FIND(",",A1)+1))
Last Name =LEFT(A1,FIND(",",A1)-1)

Regards,
Paul