I need to extract second email id from a cell. Below is sample example of data.
Example 1 : My email id is email@example.com and my official mail id is firstname.lastname@example.org
Example 2: My email id is email@example.com but you may email me at firstname.lastname@example.org
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