Hi, I found a formula that has helped me seperate e-mails into first name and second name.

For e-mails such as [email protected]



FIRST NAME: =PROPER(LEFT(A1,MIN(FIND({"@","."},A1&"@."))-1))
SECOND NAME: =PROPER(REPLACE(LEFT(A1,FIND("@",A1&"@")-1),1,LEN(B1)+1,""))

I have made a vow to myself to try and understand each formula when I've used them.

I understand most of the functions used, but I would love a translation of how it works, I don't understand the A1, MIN bit of the first formula.

I would really love to understand the grammar of these formulas so I can start writing my own.

Thanks,