One way:

First Name
=LEFT(A1,FIND(".",A1)-1)

Last Name
=MID(A1,FIND(".",A1)+1,FIND("@",A1)-FIND(".",A1)-1)

HTH,
Paul

"metaltecks" wrote in message
...
I currently have a spreadsheet that that contains an email address:
.

I want to create 2 new columns, one will have the first name and the
second
the last. All email addresses are in the format of
.

Can some one please help me.

Thank you