Learning how to use excel functions will greatly improve the efficiency of table creation. Today, the editor will share with you how to use two simple function formulas left and right in Excel. I hope you like it!

​

Use of excel functions left and right

1. First, we open a form and enter some data in the form. The data I entered is as shown in the picture (of course, you can also enter some dates or text by yourself. If the method is the same, the result will be the same.

Use of excel functions left and right

2. Select an empty cell. This cell is a cell generated by using the LEFT function to separate the data. As shown in the figure, Text is the cell from which characters are to be extracted. Num_chars refers to the cell from the left of the selected cell. The number of characters in the number, in the picture, refers to the 2 characters from the left in cell A1.

Use of excel functions left and right

3. After operating the formula in the second step, we get the following result, as shown in the figure. The 2 characters from the left in cell A1 are 40, just like what we see is indeed 40.

Use of excel functions left and right