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
That’s all dudes! =)