Something like this:

If cell one contains a text string ending with a comma (lastname,) cut and paste that text string to the new collumn.

If cell one contains a text string ending with a space (firstname )cut and paste that text string to the new column. Login to read more.