Sharepoint - Using calculated field to retrieve substring of another field

1. Create Calculated column called "UserName" and type in this formula

   =LEFT([Email Address],INT(FIND("@",[Email Address])-1))

2. Create Calculated column called "Domain" and type in this formula

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

It should work.