In Numbers how do I split the contents of one cell into more than one cell?

If the full string is in B1

two auxiliary cells
in C1 enter:
=TRIM(RIGHT(B,LEN(B)-SEARCH(",",B)))
in D1 enter:
=TRIM(RIGHT(C,LEN(C)-SEARCH(",",C)))

now the components
in E1 enter:
=LEFT(B,SEARCH(",",B)-1)
in F1 enter:
=LEFT(C,SEARCH(",",C)-1)
in G1 enter:
=LEFT(D,SEARCH(" ",D)-1)
in H1 enter:
=TRIM(RIGHT(D,LEN(D)-SEARCH(" ",D)))

Yvan KOENIG (from FRANCE mercredi 21 janvier 2009 09:30:49)