Parsing Cell Contents
 

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

Parsing Cell Contents
 

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

Parsing Cell Contents
 

With data in A1:

First name:

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

Last name:

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

HTH

"metaltecks" wrote:

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