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

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 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)&””

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!
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
  • BM

    another very useful excel tip. hindi ko alam to haha. thanks bon. thanks to

  • hehe di ko rin ito alam. new discovery ito sa akin. mas gusto ko kasi lagi doon sa word. thank you bon.

  • thanks joel and fr.fiel, =) sana nakatulong kahit konti!

  • Ang sakit sa ulo hahaha alam na! Focus…focus.

  • wow, possible pala ‘to.. thanks for the info sir bon!

  • Bigla ako nasabik sa excel… ma try nga… excel kc madadas ko gamitin instead of calculator. Sa ngayon hindi ko pa eto ma-apply. Sa mga susunood na pagkakataon sana maalala ko eto.

  • ang henyo nito.hehe.cge..aalis muna ako.mag-i-excel pa ako e.

  • taragis eto! di ko na naman alam eto! ahahah di ko magets yung formula. hahah