Create macro to separate first name and last name in email and plug it into columns

[Jyggalag]

Dear all,

I am currently working on a spreadsheet that looks like this, albeit the real one is much larger:

I was wondering if there would be some way in which I could create a macro or some VBA code attached to a macro where, once i press it, it takes the e-mails from C2-C12 and takes the first name and puts it in column A and the last name in column B. Almost all of the emails that I work with have emails that basically follow a rule of "Firstname.Lastname@email.com". If they do not have this first name separated from the last name by a dot ".", I would like for the macro to return the value "X" and "X" for both first name and last name in column A and B.

Is this possible? And if so, how might I carry out such a task?

Thank you so much for your time and assistance everybody! It is greatly appreciated.

Please let me know if you have questions or need further information and I will respond ASAP.

Kindest regards,
Jyggalag.

 

[Fluff]

If you are trying to run the macro from the button, then you have assigned the wrong macro.

 

[Jyggalag]

If you are trying to run the macro from the button, then you have assigned the wrong macro.

It works now! Perfec! Thank you so much Fluff! You continue to be my personal Excel hero :D

And apologies for the oversight on my behalf

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Jyggalag]

If you are trying to run the macro from the button, then you have assigned the wrong macro.

Out of curiosity, is the solution also possible through formulas, or would that be too complex compared to a nice VBA solution such as the one that you created?

 

[Fluff]

The macro is just using a formula. compare the formula in post#3 to the macro in post#4