Question: how to create a formula for email address in excel?
Answer: Write the formula in cell D2.
=CONCATENATE(A2,".", B2,"@",C2,".com")
Press Enter on your keyboard.
The function will create the email address.