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.