Here is something I have used before and needed to do again today. Within Excel I had a column with full name Joe Smith, and I needed to separate the two into their own fields.
For each new field I used the following formula:
Get the first name in Column C from Full name in Column A
[code[=LEFT(A1,FIND(” “,A1,1)-1)[/code]
Get Last name in Column D from Full Name in Column A
[code]=RIGHT(A1,LEN(A1)-FIND(” “,A1,1))[/code]
I know I will need this again in the future so .. consider it logged