Formats

{last}{f}@acme.com

Addresses made of the last name followed by the first initial.

Examples

Jane Doedoej@acme.com
Robert Smithsmithr@acme.com
María Garcíagarciam@acme.com
Søren Nielsennielsens@acme.com

Spreadsheet formula

With first names in column A, last names in B and the company domain in C:

=LOWER(B2&LEFT(A2,1)&"@"&C2)

Other formats