I have a list of email addresses from which I want to split out just the @ and the domain name (i.e. - @domainname.com) into an adjacent cell.
Example:
Original
A1 - nameofperson@domainname.com
A2 - x@y.com
Result
B1 - @domainname.com
B2 - @y.com
Is there a function that can do this?
NOTE: I do not know/understand VBA, so if that is the answer, please include specific details.
Thanks
Example:
Original
A1 - nameofperson@domainname.com
A2 - x@y.com
Result
B1 - @domainname.com
B2 - @y.com
Is there a function that can do this?
NOTE: I do not know/understand VBA, so if that is the answer, please include specific details.
Thanks