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...