Some netizens said that they still don’t know how to insert the LEFT function into Excel. Today, the editor will specifically describe the detailed steps for inserting the LEFT function into Excel. Friends who don’t know how to operate it, come and learn together!
1. Open the Excel worksheet,
2. Enter the sample text in the picture below in the form,
3. Enter the function we need most in cell B2: "LEFT(A2,3)".
A2 means reading the content in cell A2.
3 means intercepting a total of 3 characters starting from the first digit.
4. Press Enter and you will see that the function has taken effect. The three words "Guangdong Province" are displayed in the cell, and the interception is successful.
5. Fill down or copy this formula to other required cells, you will see your office efficiency improve immediately.
Notice
Of course, if the province has four characters, this function needs to change the "3" inside to "4" to fully capture it, and so on.
Come and learn the detailed steps of inserting the LEFT function in Excel. It will definitely help everyone.
