|Please don't try to fit your entire post into the subject line. I have edited your subject line to make it a bit more readable.|
With this in A1...
These 2 formulas will return email_id and gmail.com
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.