I have first name in column A and last name in column B. 100 rows of data.
I want to create an email address column in column C by taking the first letter of the first name and concatenating it with the entire contents of the last name and then adding @mydomain.com .
Can someone help me with the formula to put in Column C?
Thanks so much!