SharePoint Calculated Field: Extract Email UserName and domain from an email field

If you have a need to extract name and/or domain from an email column, here's how to do it in SharePoint

Go to library settins, add a new text email column via 'Create Column', call it Email,

Go to library settings again, here we are going to add 2 new columns:

Create a new calculated column called "Name" and type in this formula

=LEFT([Email], Int(FIND("@",[Email])-1))
Like So:


Create a new calculated column called "Domain" and use this formula

=RIGHT([Email],LEN([Email])-INT(FIND("@",[Email])))

We now will have:

===========================================================
|  Email                          |  Name            |      Domain       |
===========================================================
| Jason@att.com           |   Jason            |   att.com  |
| HelloJason@ms.com   |   HelloJason    |   ms.com  |