Try this:

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


" KB916521 Junk Update Office 2003 -A" wrote:

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.