I have this in a single cell "lastname, firstname"

Eg:

"smith, john"

*Note there is a a SPACE between the comma and second work in the cell "smith, john"


I'm looking for these outputs:

firstname.lastname@email.com or john.smith@email.com

first letter (of firstname)lastname@gmail.com or jsmith@email.com

Any help would be great.


Thanks.