How to Extract Initials from Name in Excel

You can use the following formula in Excel to extract the initials from a name:

=LEFT(TEXTBEFORE(A2, " "),1)&LEFT(TEXTAFTER(A2, " "),1)

This particular formula extracts the initials from the name in cell A2.

For example, if cell A2 contains Andy Moss then this formula would return AM.

The following example shows how to use this formula in practice.

Example: How to Extract Initials from Name in Excel

Suppose we have the following column of names in Excel:

Suppose we would like to extract the initials from each name in column A.

We can type the following formula into cell B2 to do so:

=LEFT(TEXTBEFORE(A2, " "),1)&LEFT(TEXTAFTER(A2, " "),1)

We can then click and drag this formula down to each remaining cell in column B:

Excel extract initials from name

Column B now contains the initials from each name in column A.

For example:

And so on.

Recall the formula that we used to extract the initials from the name in cell A2:

=LEFT(TEXTBEFORE(A2, " "),1)&LEFT(TEXTAFTER(A2, " "),1)

Here is how this formula works:

First, we use TEXTBEFORE(A2, ” “) to extract all text before the first space. This returns Andy.

Then we use the LEFT function to only return the first character on the left. This returns A.

Then, we use TEXTAFTER(A2, ” “) to extract all text after the first space. This returns Moss.

Then we use the LEFT function to only return the first character on the left. This returns M.

Lastly, we use the & symbol to concatenate together A and M to get AM as the final result.

The same process is repeated for each name.

The following tutorials explain how to perform other common operations in Excel: