Need to extract second email id

Hi All,

 

I need to extract second email id from a cell. Below is sample example of data. 

Example 1 : My email id is xyz@gmail.com and my official mail id is exm@gmail.com

Example 2: My email id is xyz@gmail.com but you may email me at exm@gmail.com

 From the above example, I could not get success using MID function. If both email id is same domin and the length of sentance may change.

 

By: Kundan Kumar

Leave a Reply

Your email address will not be published. Required fields are marked *