How to separate first name and last name in Open Office calc

How often to you get a spreadsheet or CSV file with the first and second name in one column. These little formula will solve the problem.
If the name David Harvey was in column A
B2: =LEFT(A2;SEARCH(" ";A2)-1) This does the first name "David"
C2: =MID(A2;SEARCH(" ";A2)+1;LEN(A2)) This does the second "Harvey"