FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The LEFT function in Excel is a type of text function in Excel that gives the number of characters from the start of the string, from left to right. So, for example, if we use this function as =LEFT ( “ANAND”, 2) this will give us AN as a result. From the example, we can see that this function takes two arguments.

Detailed explanation-2: -LEFT returns the first character or characters in a text string, based on the number of characters you specify. LEFTB returns the first character or characters in a text string, based on the number of bytes you specify. Important: These functions may not be available in all languages.

Detailed explanation-3: -The LEFT function returns the specified number of characters from the start, or the left, of a text string. The syntax for the LEFT function looks like this: =LEFT(text, [num chars]). Click in the cell where you want to insert the function.

Detailed explanation-4: -As you probably know, the Excel LEFT function returns the specified number of left-most characters in a string. And you use the FIND function to determine the position of a space (” “) to let the LEFT function know how many characters to extract.

Detailed explanation-5: -These are text functions. In the LEFT function, you can pull a set number of characters out of a cell into another cell starting at the leftmost point. The RIGHT function performs the same except starting at the rightmost point. Both functions are related to the MID function, which we covered back in September.