I've got a single cell containing a first and last name, seperated by a
space. I need to break it into two cells:

I've got I need
Cell1 Cell2 Cell3
John Doe John Doe

I was thinking my formula would be:

=Left(A1,Find(" ",A1)25)

But no joy...

Thanks in advance!
steve