Suppose you have a list of Names, and you only want the initials of the people.

There's an easy way to do this in Excel

Here's our data:

The formula we use is:
=LEFT(B3)&MID(B3,FIND(" ",B3)+1,1)

Download Example Sheet to practise getting initials from a list of name

Video Training: Get Initials from Name