I have an exported excel file from MS ACCESS that is fine but some don't have email addresses, But they are all the same that is, Lastname. (put in a '.')Firstname@dcf.nj.gov
How can I make a formula that will do this?
Data
Lastname Firstname email
Smit Joe currently...