Suppose I have a field that contain the following data:
========================== | Email Address | ========================== | [email protected] | | [email protected] | | [email protected] | ==========================
Is there a calculated formula in SharePoint that will give me the following result? (It will help me to retrieve the sub-string from the Email Address column and give me the answer as shown in the UserName and Domain column):
=========================================================== | Email Address | UserName | Domain | =========================================================== | [email protected] | Jack | wonderland.com | | [email protected] | Peter | nobodyland.com | | [email protected] | Jill | wonderland.com | ===========================================================