Skip to Content
0
Aug 08, 2023 at 12:55 PM

Substruction of email address from text

90 Views

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?