Use the Excel function left and right tutorial

In learning Excel This form tool, many netizens will search some Excel tutorials, and among them, most people search is about the use of Excel function of the tutorial, because the use of Excel function, will greatly improve the efficiency of table production. Today small, small make up for everyone to share a simple function formula left and right method of use, hope you like it! Excel2

1. First we open a table, in the form of random input some data, I entered the data as shown in the picture (of course, you can also enter some of their own dates or text, the same way the results will be the same.)

2. Select an empty cell, which is the cell that is used to create the data that we separate from the left function. As shown in figure text is the cell to extract the characters, num_chars refers to the number of characters from the left in the selected cell, which refers to the left 2-bit characters from the A1 cell.

3. After the second operation of the formula, we have come to the following results as shown in the figure, the A1 cell from the left 2-digit character is 40 as we see is indeed 40.

The 4.right formula is basically the same as the left formula, they have the same requirements for cells that need to be detached, but in the formula: Num_chars refers to the number of characters from the right in the selected cell, and the following is the analysis directly from the right-hand formula, as shown in the formula in the figure.

5. As shown in the figure, the A1 is a cell that needs to be detached, 2 refers to the 2-bit character from the right of the A1 cell, and the result is the 66 we see, which is the simple use of these 2 formulas, hoping to help everyone

　Note:

Right formula and left formula you should be careful not to confuse it when you use it, but the first part of the formula is the same, but they are the number starting from the different sides of the selected cell. We must pay attention to it.

The above is excel in 2 formulas left and right in the form of the use of detailed, hope to help everyone!