Formula to manipulate string

[Duberry]

Hello,

I am seeking a formula to manipulate strings like the example below:

Cell A1 has a value of "Smith, John". I would like Cell A2 to show like "smithjatexampledotcom" (this would be an email address, but I am not allowed to post links)

Thank you

[BMV]

Please Login or Register  to view this content.

in the case of after coma always one space then

Please Login or Register  to view this content.