Excel Guides

Pulling Initial Letters from a String in Excel

There are a few ways to pull initial letters from a string in Excel. One way is to use the LEFT function. The LEFT function takes two arguments: the text string and the number of characters you want to extract from the left side of the string. For example, if you have a list of names in column A and you want to pull the first letter of each name into column B, you would use the following formula:

=LEFT(A1,1)

You can then drag this formula down column B to apply it to all cells in that column. Another way to pull initial letters from a string is to use the MID function. The MID function takes three arguments: the text string, the starting position, and the number of characters you want to extract. For example, if you have a list of names in column A and you want to pull the first letter of each name into column B, you would use the following formula:

=MID(A1,1,1)

You can then drag this formula down column B to apply it to all cells in that column.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.