How to create email address with name and domain in Excel
Atimes a user may want to build an email address from a first and last name. In that case, use a formula based on simple concatenation with help from the LEFT and LOWER functions. See illustration below: Formula =LOWER(LEFT(first)&last&”@”&domain) Explanation In the example shown, the formula in D5 is: =LOWER(LEFT(B5)&C5&”@”&$G$6) How this formula works Working …