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