Extracting firs name and last name

[Josh]

Hi folks,

in column A I have lists of lastname then a comma and then
first name....

Like Johnson , Alex

I like to be able to use a formula in columns B and C so
that only the last name appears in column B and only first
name in column C.

Any idea ?

Thanks

 

[tjtjjtjt]

You may want to try the Text to Columns feature, but these two formulas do
what you are asking:

First Name:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))

Last Name:
=LEFT(A1,FIND(",",A1)-1)

tj