Formats
{last}{f}@acme.com
Addresses made of the last name followed by the first initial.
Examples
| Jane Doe | doej@acme.com |
| Robert Smith | smithr@acme.com |
| María García | garciam@acme.com |
| Søren Nielsen | nielsens@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)