Data > Text to columns will keep the first name in column A and move th
second to column B.

If you still want to retain the full name in column A then copy colum
A to column B, select column B and use Data menu > Text to column
option with space as delimiter.

Alternatively, using formulas, in B1

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

and in C1

=REPLACE(A1,1,FIND(" ",A1),""

Hi Digital2K,

Highlight all of your names in column A.
Goto Data>Text to Columns.
In the first page of the wizard select delimited then click next.
In the second page of the wizard check space (make sure all other
options are unchecked.) then click next.
In the third page in destination put $B$1 and click finish.

These directions are for Excel 2000, if you have a different version
the process may be a little different but the basics should be the same.

HTH
Martin

Select the column, go to Data>Text To Columns, click the delimited button,
check space delimiter box, and Finish

Michael is just giving an advisory notice that you may have to
tweak the results.   With programming one has more control and
can write a bunch of exceptions and manually correct others.   Something
made more difficult if relying on Worksheet Formulas and/or
starting over each time with  a listing.    Examples for three or
four names is a bit rough considering that the OP said they
start with first and last names meaning no titles and somebody
presumably removed extraneous initials would leave only
compound first names and compound last names as a problem.

The obvious answer would be that CHAR(160) were included
in compound names (including III and Jr, Sr),  no titles are included,
and CHAR(160) is treated same as  space for sorting.  But it
also depends on who the list is intended for.