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 and my official mail id is

Example 2: My email id is but you may email me at

 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 *