Hello everyone,
I am trying to extract the full name from the email address but I am stuck with middle names.
Example: remusovidiu.baisan@gmail.com I need to be turned into Remus Ovidiu Baisan.
So far my formula managed to bring: Remusovidiu Baisan
Formula used: =SUBSTITUTE(PROPER(LEFT([@Email],FIND("@",[@Email])-1)),"."," ")
Any tips?
I am trying to extract the full name from the email address but I am stuck with middle names.
Example: remusovidiu.baisan@gmail.com I need to be turned into Remus Ovidiu Baisan.
So far my formula managed to bring: Remusovidiu Baisan
Formula used: =SUBSTITUTE(PROPER(LEFT([@Email],FIND("@",[@Email])-1)),"."," ")
Any tips?