I am trying to find a way to generate email addresses from the first name and the first letter of a last name. I used the CONCATENATE function, but it will only take a full cell, not a first letter.
You may use
REGEXTRACT. See the example below:
Here is another example:
Other ways to get the first character of a string (assuming here that the last name were in B2):
Another (shorter) way to concatenate (assuming a first name were in A2 and a last name in B2):
And this is the type of operation that array formulas are meant to address. So, assuming your first names were in A2:A and your last names in B2:B:
1.) Delete ALL of Column C (or any other column that is open for use).
2.) Place the following in cell C1: