Excel-extracting names into seperate elements

Hello,

I have several hundred names in an excel file written like this Doe, John A and I want to seperate them into 2 columns with first names in one column and last names in another. Is there a way to extract the first word from each cell (their last name) into a cell? Or even better, can I get them separated and put into 2 seperate cells?

Thank you in advance!