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,
Bookmarks