Extract Name From Email Address?

I have a list of email addresses. Most of them are in the format of: firstname.lastname@domain.com

There are about 200 of them. I wish to extract the firstname and lastname into seperate columns so i end up with:

Code:
A | B | C
--------------------------------------------------------------
Firstname | Lastname | firstname.lastname@domain.com

I am sure I came across something before that did something like this. but I was not able to find it. Any macro or script to perform this extraction.

note that some of the addresses are in the format: name@domain.com In those cases I would like just everything before the @ put into column A. I will then manually figure out how the value is to be broken up into firstname / lastname.