is it possible to split the contents of a cell into two cells?

ex: "Robert Smith" is in one cell, but i want it to split to "Robert" and "Smith".

basically there's a name column, but the database has first name & last name columns.

thanks