How to separate 1st and Last names in 1 cell (in numbers) to 2 cells

Fluffymind wrote:
I have about 1000 names in a numbers spreadsheet with information in separate columns such as phone numbers etc.

But the names, 1st and last, are in 1 cell with a space between them. How do I separate them into 2 cells?

Thank you so much for your help

Names in column A.
All names are of the pattern xxxxxxx xxxxxxxxx (two names only, separated by one space)

In the column where you want first names:

=LEFT(A,FIND(" ",A)-1)

In the column where you want last names:

=MID(A,FIND(" ",A)+1,LEN(A)-FIND(" ",A))

Regards,
Barry

Look at :
http://discussions.apple.com/thread.jspa?messageID=13109185

Yvan KOENIG (VALLAURIS, France) jeudi 17 mars 2011 10:53:30