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