How does one extract names and emails from Gmail Pack columns?

Dear @P_C,

Would you mind to share this in a doc, because I am rather confused as in my test doc it shows the right names.
image

Maybe it’s a good idea to try again and to use the given module in the Gmail pack to avoid having mistaken formulas :thinking:

The issue is that the email addresses are constructed in a way the sender has given. Sometimes you don’t get a name at all. Imagine: info@abc.com, reception@hotel.info and like in your sample you can have johndoe289@cox.net, johndoe@cox.net

I am rather sure that this post :point_down: will be the way to go, but as usual, some more details of your use case will give a better chance to come with a solution