Extract Name from Email Address

[remusbv8]

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?

 

[Michael M]

This a little shorter, but returning a middle name without any identifier will be much more difficult

=PROPER(LEFT(A1,FIND("@",A1,1)-1))

 

[Peter_SSs]

This a little shorter

.. largely because your formula does not replace the "." with a space like the original.

 

[Michael M]

.. largely because your formula does not replace the "." with a space like the original.

Yeah...good point....I didn't even see the "."

 

[remusbv8]

Thanks for the answers!

I was more curious if I can find a solution to extract the middle name too.

 

[Michael M]

How are we going to know where the middle name actually starts or a middle name even exists ??

 

[Peter_SSs]

I was more curious if I can find a solution to extract the middle name too.

Without more information, that is not possible (as Michael has already alluded to). For example, without further information
albarobert.baisan could be "Alba Robert Baisan" or "Albaro Bert Baisan" or something else again.

If somewhere in your workbook you had a list of name details like below then it would be more likely that the names could be separated

remusbv8.xlsm
	A	B	C
1	First	Middle	Last
2	Remus	Ovidiu	Baisan
3	Andrei		Aldea
4	Albaro	Bert	Baisan
Sheet2