Hi All,
Is there any universal method (by using formulas) to get the email adress from text in a cell?
In my case email address is always separated by space, cointains the "@" sign but it's sometimes first string in text sometimes in middle sometimes it's the last string.
For sure "@" is only once per cell so I am able to fetch the string (domain) after "@" sign by POS. But how to get a "user"?
Do you have any idea how to solve that tricky part?