splitting text in open office calc based on space

Posted by gjergj.sheldija on July 14, 2011

paste them in different columns

=LEFT(D2,FIND(” ”,D2))
=MID(D2,FIND(” ”,E2),255) 