Hi there, i was wondering if anyone can give me a hand. I remember once seeing a formula someone had made to generate email addresses in excel to later import to another program.

What I have is a spreadsheet with a person´s full name in the form: david william smith
What I´d like to do is use this full name to generate an email address of the form: dwsmith@example.com

I presume it is easy to do, but I have little time to study this and get it working.

Hope someone can help me!!!