Parsing Cell Contents

M

metaltecks

I currently have a spreadsheet that that contains an email address:
[email protected].

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
[email protected].

Can some one please help me.

Thank you
 
P

PCLIVE

One way:

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

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

HTH,
Paul
 
T

Toppers

With data in A1:

First name:

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

Last name:

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

HTH
 
Top