gerhuman.blogg.se

The result would R, which is an initial or first character of Ram in the example. Step 3: Just close the bracket to complete the syntax or just press Enter.

So, in this example, we want an initial so take it as 1. Like the below picture, we have to put a comma and then the number of characters that we want to extract. Step 2: Now, we have to enter the syntax, cell address which is A4, for which we have to extract the substring. Step 1: We will apply the LEFT formula in cell B4.

Suppose, in a report we have to give only the initial of a given name, then in this scenario, the LEFT function will help us. Now, we will see the example with the optional argument (num_chars). Hence the result is the whole string which is Eye. Now, we will see the other scenario where the optional argument is greater than the number of words then, it will return as a whole string or word.Īs we can see from the above example, the optional argument, which is num_chars, is written as 5 however, Eye’s example is only of three characters. Hence the result is F, which is the first character of the Function from the left. As we noted earlier in this article, if the optional argument whose syntax is num_chars is not given, it will automatically come as default 1. We can see from the above picture that the result or output of the Formula is “F “. Step 3: As we do not have to use the optional argument in this example, we have to just click enter or close the bracket or press enter.

So, in the above picture, we are using the LEFT function for the cell address A5, which is written as Function. Step 2: We can see in the above pic that it is asking for text, it means the word or string for which we have extracted the string, so we can use the cursor or put the address of the cell manually as well. Step 1: We have to start the formula from “ =“, then type LEFT and then tab. You can download this LEFT function Excel Template here – LEFT function Excel Template Example #1įirstly, we will see the example of a LEFT function without an optional argument to make it clear of usage: