MS Excel problem

[macko]

I am working on a mailing list in Excel. My first column unfortunately has the persons first and last name. I need to put the first name and the last name in their own columns. The first name and last name is seperated by a space. I know it can be done, just no idea how. Does anybody know how to do this? Thanks in advance.

[DVNT1]

if the name was in A1, then...

B1 =LEFT(A1,(FIND(" ",A1)))
C1 =MID(A1,(FIND(" ",A1)+1),LEN(A1)-FIND(" ",A1))