I have a spreadsheet with a column that contains names. They are all in this format:

lastname, firstname
example: WASHINGTON, GEORGE

All the individuals have e-mail addresses based on their names. They are:

firstname.lastname@email.com
[email protected]

It's not really "@email.com" but I don't want to mention the company name. How would I set this up in another column? Or, how would I break apart the names so the first names are in one column and the last name is in another? I would then be able to combine them with the @email.com after them. Thanks!