How do I separate a list of emails into two columns?

[lindabaiamonte]

Hi All,   I have a column that contains personal and work email addresses.   I would like to separate them into two columns.   I am having trouble trying to figure this out.

jane.doe@personal.com

jane.doe@work.com

john.smith@personal.com

john.smith@work.com

mary.brown@personal.com

mary.brown@work.com

I was thinking of using a IF Contains formula, but I do not know how to tell it to put the full email address.

if this column contains '@work.com' then put that full email into a new column

Any ideas?

[ChrisTX]

Are the rows always ordered personal first, then work?  Do all work emails end with the same "@xyz.com"?  I'm guessing some people may not have a personal email address listed?

Chris

[JosephSerpis]

Hi @lindabaiamonte the attached produce the output you describe the challenge you will face is correctly identifying the email accounts.

[binuacs]

@lindabaiamonte 

[NikyN]

Hello @lindabaiamonte,

Please find attached solution!

As work email is easy to identified, because you know all domains you can have within the company, so you can base on that decide whenever it should be personal or work column.

Best Luck!

Niky 

[lindabaiamonte]

Hi Chris,  the emails are In a mixed up order.  The work emails do end in all the same format.    @xyzcompany.com

[amruthas2]

Hi @lindabaiamonte 

I have used simple IF statment formula to get 2 different columns to identify work/personal mail id,
Let me know if this helps

Work Email
IF FindString([Email], "@work.com")>0
THEN [Email]
ELSE ""
ENDIF

Personal email

IF FindString([Email], "@work.com")<0
THEN [Email]
ELSE ""
ENDIF