extract first and last name from email adress

[howard]

I would like a formula to extraxt the first and last name from an email address and as well as for the first and last name to start with upper case for e.g email address patrick.davids@syke.pl.com


this should appear as Patrick Davids using a formula



your assistance in this regard is most appreciated

 

[FormR]

Hi, one (of probably many) option.

Excel 2013/2016
	A	B
1	patrick.davids@syke.pl.com	Patrick Davids
Sheet1

Cell Formulas
Range	Formula
B1	=PROPER(SUBSTITUTE(LEFT(A1,FIND("@",A1)-1),"."," "))

 

[Fluff]

How about
=PROPER(SUBSTITUTE(LEFT(A2,FIND("@",A2)-1),"."," "))

Beaten 2it

 

[howard]

Thanks for the help Guys, much appreciated

 

[Fluff]

Glad we could help & thanks for the feedback