Now Reading
How to pull the first letter of a word in Excel
8

How to pull the first letter of a word in Excel

by Bon Francisco Talampas, Jr.November 11, 2010

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! =)

What's your reaction?
Thumbs up!
0%
Cool
0%
Happy
0%
Laugh
0%
Sad
0%
Angry
0%
Gun
0%
About The Author
Bon Francisco Talampas, Jr.
Bon Talampas, Jr. is a computer engineer, a former member of a technical team that supports a leading health care company. Prior to his stint abroad, he worked as an IT specialist and a university lecturer. Bon also holds an MBA. And aside from being a computer geek and DOTA fanatic, he spends most of his idle hours in blogging and photography. You can also read more about him at www.bonistation.com.

Leave a Response