Excel Formula To Get First Letter Of Each Word - Web nov 11, 2011. To extract the first letter of each word, you can use the left function in combination with other functions, such as the find and mid functions. For example, if cell a2 contains the dallas mavericks then this formula would return tdm. Web you can use the following formula in excel to extract the first letter of each word in a cell: This particular formula extracts the first letter of each word in cell a2. Hi all, am using the formula. If cell a1 contains the text excel tutorial, the formula =left (a1, 1) would return e as the first letter of the first word.
To extract the first letter of each word, you can use the left function in combination with other functions, such as the find and mid functions. Web you can use the following formula in excel to extract the first letter of each word in a cell: Hi all, am using the formula. For example, if cell a2 contains the dallas mavericks then this formula would return tdm. This particular formula extracts the first letter of each word in cell a2. If cell a1 contains the text excel tutorial, the formula =left (a1, 1) would return e as the first letter of the first word. Web nov 11, 2011.