Formua too remove dot

[howard]

I have the following formula to extract the name and surname from an email address.


I need to amend the formula so that dot (.) does not appear between the name & surname

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

your assistance in resolving this is most appreciated

Book1
	A	B
3	Dave.Costa	dave.costa@ghom.com
Sheet1

Cell Formulas
Range	Formula
A3	=PROPER(LEFT(B3,FIND("@",B3)-1))

 

[AlanY]

try substitute the . with space

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

 

[howard]

Thanks for the help, much appreciated

 

[AlanY]

you're welcome