Extract First and last name from Email address

[howard]

I am looking for a formula to extract the first name and last name in one column in Proper Case from email address below

 neil.michaels@tnsa.com

It must appear as Neil Michaels

I have tried using the formula below

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

The result is Neil.Michaels


Your assistance in this regard is most appreciated

 

[Joe4]

Try:

=PROPER(SUBSTITUTE(LEFT(F2,FIND("@",F2)-1),"."," "))

 

[howard]

Thanks for the help Joe


formula works perfectly

 

[Joe4]

You are welcome.
Hopefully, it makes sense. Basically, your formula was 90% of the way there. Just added the SUBSTITUTE function to substitute a space in for all periods it finds.

 

[howard]

I have used the the substitute formula before, but never thought of using it in this in instance

It makes perfect sense thanks