Separate data from one cell to two different cell

[minrush]

Please let me know how I can separate

11151 Danel Kane (in cell a1)

into

11151 (in cell b1) Danel Kane (in cell b2)

thank you

 

[Lewiy]

Either:
with the value in A1, in B1 put

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

for the first bit and in C1:

=RIGHT(A1,LEN(A1)-LEN(B1)-1)

For the second bit.

Or use Data>Text to Columns