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!!!

Johnny

Formulas is not my stong point so someone else may offer a better solution

Assuming name is in A3

=LEFT(A3,1)&MID(A3,FIND(" ",A3,1)+1,1)&MID(A3,FIND(" ",A3,FIND(" ",A3,1)+1)+1,LEN(A3))

__________________
Please Read Forum Rules Before Posting

Wrap VBA code by selecting the code and clicking the # icon or Read This

How To Cross Post politely

If my reply has assisted or failed to assist you I welcome your Feedback.