Excel-extracting names into seperate elements

GoldBar - Feb 2, 2011 at 03:12 PM
 Steveinuk - Feb 3, 2011 at 03:35 AM

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!


1 response