JUST TAKE A FEW OF THESE NUMBERS IN EXCEL?

This can be solved with the mid function, as follows: click b8 and enter mid(cell, 1, 2). Note: "Cell" is the cell where your data is located, "1" is the first number from the left, "2".

is the number of takeouts, you can also modify it.

Function usage to be used:

Select text: mid (the original text paragraph given, starting from the first digits, how many digits to choose) Find the position: find (find "what", the given paragraph).

Assuming that C25 is in cell A1, the final result is placed in cells B81, A1=C25, and C25 is selected

It is equivalent to starting from the position of "c", and selecting "5", the formula in b8 is: =mid(a1,find("c",a1),find("5",a1)-find("c",a1))

Which digit to start with - [find(.]"c", A1)]: Start with the position where C is located.

How many bits to choose - [find(.]"5",a1)-find("c",A1)]: Subtract the position of "c" from the position of "5", then it is the number of digits we want to choose.

The above formula is a general formula in C25 Fine Stone, C25P6.

Extension: In this problem, because C25 is merged, the generality of this formula lies in:

For example, a1 = c2 fine stone 5p6, then this formula is chosen as "c2 fine stone 5".

Hope it helps.

1. Excel** required.

2. If it is a pure number, enter =left in the cell where the result is entered.

3. Enter the cells to be extracted and how many numbers you want to extract in parentheses, and press the enter key after entering.

4. If it is a mixture of numbers and letters, enter =mid in the cell where the result is entered.

5. Enter the cells to be extracted, the number of digits to be extracted, and the number of digits to be extracted in parentheses, and press the enter key after entering.

This article is based on the Dell Inspiron 5000 brand, Windows 10 system, Microsoft Office Excel 2019 version.

This can be achieved using Excel's MID formula. Enter =mid(a1; 3;3), that is, A1 means the data of the target unit, the first 3 means the number from the third digit, and the second three represents the number of digits from the third digit. Specifically, take Excel2007 as an example, and the setting method is as follows:

1. Open an excel file on your computer to enter.

2. Enter the required number after entering the file.

3. Enter =mid(a1; 3;3)。

4. After the formula is entered, press the enter key to see that the three digits from the third to the fifth digit in the group of data have been taken out.

In Excel, you can use the MID function to extract the first digit of a string of numbers in a cell.

Tool: Office2007

Here's how: Extract the first digit from b1:

The input formula is as follows:

You get the first digit:

By analogy, as long as the second parameter of the ridge in the mid function is changed to the number of digits to be extracted, the number of the specified digits can be obtained:

Note the key field lease matter: add in front of the mid -- is to convert the text number into a numeric number by two negative number operations.

1.Extract the first cell numberIn Excel, extract the first cell number manually. 2.

1. Open Excel** and enter the content that needs to be extracted in column A cells.

2. Enter the function formula in cell B1: =left(A1,len(A1)-5), which means take the value in A1 as the basis and remove the 5 digits from the bottom of A1.

3. Click the Enter key to generate the calculation result of the function formula, and the characters in the last five digits of the A1 cell have been removed in the figure below.

4. Drag down the copy formula to extract part of the data in column A in batches.

How to extract the numbers in ** separately? Just copy-paste.

Function usage to be used:

Select text: mid (the original text paragraph given, starting from the first digits, how many digits to choose) Find the position: find (find "what", the given paragraph).

Assuming that C25 is in cell A1, the final result is placed in cells B81, A1=C25, and C25 is selected

It is equivalent to starting from the position of "c", and selecting "5", the formula in b8 is: =mid(a1,find("c",a1),find("5",a1)-find("c",a1))

Which digit to start with - [find(.]"c",A1)]: How many digits to choose from the digit where C is located - [find(.]"5",a1)-find("c",A1)]: Subtract the position of "c" from the position of "5", then it is the number of digits we want to choose.

The above formula is a general formula in C25 Fine Stone, C25P6.

Extension: In this problem, because C25 is merged, the generality of this formula lies in:

For example, a1 = c2 fine stone 5p6, then this formula is chosen as "c2 fine stone 5".

Hope it helps.

This can be solved with the mid function, as follows: click b8 and enter mid(cell, 1, 2). Description:

"Cell" is the cell where your data is located, "1" is the first number on the left, "2" is the number taken out, you can also modify it.

Quite simply, e.g. =mid(a1,1,3) (a1 is the cell, 1 is the first place, and 3 is the third place) to calculate the following result.

=left(b8,3) means that cell b8 takes 3 digits from the left.

The corresponding ones are right() and mid().

You've posted this question many times, isn't it easy to enter it directly if it's just c25?? Or left.