How to extract the first few numbers in excel

How to extract the first few numbers in excel: first open the Excel table; then find the data that needs to extract the first few numbers; then enter the formula "=LEFT(A2,11)" in cell B2; finally Press the Enter key to get the extraction results.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Recommended: "Excel Tutorial"

1. As shown below, you need to extract the first 11 digits of the contact information in this column;

2. First enter the formula =LEFT(A2,11) in cell B2, and then press the Enter key to get the extraction result;

3. Then put the mouse on the lower right corner of cell B2, pull down and fill in the formula, and you can quickly extract the first 11 digits of the data in column A, which is also the first mobile phone number.

The above is the detailed content of How to extract the first few numbers in excel. For more information, please follow other related articles on the PHP Chinese website!