excelismagic

asked on

# split user ID and domain name from email addresses using formula

attached is the file with example data , column A is what i have and column B C D is what i need to get with formula.

any help is appreciated.

EE.xlsb

any help is appreciated.

EE.xlsb

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

thanks

=LEFT(A2,(FIND("@",A2,1)-1

For Domain with extention:

=MID(A2,FIND("@",A2)+1,256

and for Domain without ext:

=MID(A2,FIND("@",A2)+1,FIN

Please find attached for your reference:

EE_3-v1.xlsb