How to process 10100100 and 101020 in Excel?

How to automatically sort 1 0 100 100 and 1 0 10 20 1000 using a formula in excel

Method 1: Sort into columns

Use "*" as the delimiter to separate columns.

Method 2: Use formula

In order to help players who have not yet solved the puzzle, let us learn about the specific methods of solving the puzzle. One of the key steps is to use the formula "B1=--LEFT(A1,FIND("*",A1)-1)". This formula can help us extract the key information in the puzzle. Hope this tip helps you all!

In order to help players who have not passed the level yet, let us learn about the specific puzzle solving methods. For a formula like C1=IF(COLUMN()-1, we can solve the problem through the following steps:

Copy the C1 formula to the right.

How to write a formula in Excel to separate the odd-numbered rows and even-numbered rows of a certain column in order

Assume that the data to be divided is in column A, starting from A1, then:

In order to help players who have not passed this level yet, let us learn about the specific methods of solving the puzzle. A key formula is "odd row formula =INDIRECT("A"&INT(ROW(A1)*2)-1)". This formula will help you solve the puzzle. Remember, mastering this formula will make it easier for you to pass the level.

2. Even-numbered row formula =INDIRECT(＂A＂&INT(ROW(A1)*2))

INDIRECT function in formula:

3. Purpose: Return the reference specified by the text string. This function immediately evaluates the reference and displays its contents. Use the INDIRECT function when you need to change the reference to a cell in a formula without changing the formula itself.

4. Syntax: INDIRECT(ref_text,a1).

5. Parameter: Ref_text is a reference to a cell. This cell can contain A1 style references, R1C1 style references, names defined as references or references to text string cells; A1 is a logical value, Indicates the type of reference contained in cell ref_text. If a1 is TRUE or omitted, ref_text is interpreted as an A1-style reference. If a1 is FALSE, ref_text is interpreted as an R1C1-style reference.

6. Example: If cell A1 stores text B1, and cell B1 stores the value 68.75, the formula "=INDIRECT($A$1)" returns 68.75.

INT function in formula:

7. Purpose: Round down any real number to the nearest integer.

8. Syntax: INT(number)

9. Parameter: Number is any real number that needs to be processed.

10. Example: If A1=16.24, A2=-28.389, the formula "=INT(A1)" returns 16, and =INT(A2) returns -29.

ROW function in formula:

11. Purpose: Return the line number of the given reference.

12. Syntax: ROW(reference).

13. Parameter: Reference is the cell or cell range whose row number needs to be obtained.

14. Example: The formula "=ROW(A6)" returns 6. If the formula "=ROW()" is entered in cell C5, the calculated result is 5.

The above is the detailed content of How to process 10100100 and 101020 in Excel?. For more information, please follow other related articles on the PHP Chinese website!