Given that you have hundreds of records of employee names, and you need to take down their initials or make a list of email accounts in a given format.

Here, we will learn how to extract a letter from a given word in an excel sheet.

We need to pull the employee’s Last name and append the initial of the First name. (eg. Yin, Chao = YinC) and include the @taragismail.com at the end of each result  to make a standard email account.

This should be the result or output for the email account cell

Here’s the formula that you will provide in B2

=LEFT(A2,FIND(” “,A2)-2)&MID(A2,FIND(” “,A2)+1,1)&”@taragismail.com”

After typing the formula, drag it down to take effect in the other cells.

If you want to take the initials of Last name & First name ( Yin, Chao= YC)

The formula should be

=LEFT(A2,1)&MID(A2,FIND(” “,A2)+1,1)

That’s all dudes! =)