Put in B1: =LEFT(A1,SEARCH(" ",TRIM(A1))-1)+0
Put in C1: =MID(A1,SEARCH(" ",TRIM(A1))+1,99)

Slight revision to above. Use instead:
In B1: =LEFT(TRIM(A1),SEARCH(" ",TRIM(A1))-1)+0
In C1: =MID(TRIM(A1),SEARCH(" ",TRIM(A1))+1,99)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----