Excel number correction problem, about excel table number modification problem

It's too easy, and there's one easiest way to do it.

Let's assume that your number is a3:a90, 1, you first find an empty cell, such as b2, enter it inside, 2, position the cursor of the current cell in b2, and press Ctrl+C to copy this cell.

3. Select A3:A90 and use the menu "Paste Special".

4. In the "Paste Special" dialog window that opens, select the two single options of "Numeric" and "Multiply", and then click OK.

The above operation completes the operation of multiplying the values of a3:a90.

Let's change the content of b2 to 25, still follow the steps above, but select the two single options of "value" and "plus" in step 4.

Well, now you're done.

Of course, there are many ways to fulfill your requirements, but this is the most intuitive, after the operation, the B2 unit does not need to be kept, just empty it.

I'll try this one, the easiest:

Suppose you have a column in this column, select the b1 cell after a1 and enter : in b1

a1*, then press enter, and then select b1 to pull down and copy to the same position as column a.

Enter and 25 in 2 empty cells respectively, copy, select the original data, right-click to paste selectively, multiply, OK, copy 25, select the multiplied data, right-click to paste selectively, add, OK.

If the data column is column A: enter =A1* in column B1, then double-click the lower right corner of the cell to automatically fill the whole column, and then select the column to copy and paste it selectively. Just select a value. The goal is to get rid of the formula.

It's best to use the phrase "Easy Table." net”。Excel has many limitations, and it is cumbersome to work with some complex data.

You can use columnization (inserting a blank column to the right of the data row before splitting).

Select the data you want to sort - Data - Column - Fixed width (click next) - click once between year and 0 (click next) - Done.

There is no solution yet...

Click on the column, - Find - Replace - Replace All.

Enter year in the lookup, and do not need to enter in the replacement, OK.

If you want to participate in the operation:

a1：b1：="39"&a1

If it just looks like it is:

A1: Format Cells -> Type: 390

If your data are all 6-digit integers, then just enter 390000000 in a blank cell and copy the cell, select your data, right-click--- paste selectively--Operation, click Add-OK.

=--"39"&a1

Then copy the formula down, copy the new column generated by the formula - paste it selectively - the value.

If your data is in column A. From a1:a1000

Then enter =right(a1,16) in b1, and then fill in the formula below.

If the card numbers are all the same, that's easy to do!

Ensure that the test number format is common or numerical).

For example, the test number is: 105001, 105002, 105003......Their positions are A1, A2, A3

Then you add another column, in b1, so that the value in it is "=a1-100000".

Then you can use the fill function to do a lot of work.

The data is divided into fixed widths.

Delete the first column when it is divided.

It's more troublesome, but just be patient.

For example, if the start time 20080602092744 is in cell A1, the end time 20080602092928 in cell A2.

That enters in b1:

You can get 20080602093018.

In b2 enter:

minute(time(left(right(a2,6),2),mid(right(a2,6),3,2),right(a2,2))-time(left(right(a1,6),2),mid(right(a1,6),3,2),right(a1,2)))60+second(time(left(right(a2,6),2),mid(right(a2,6),3,2),right(a2,2))-time(left(right(a1,6),2),mid(right(a1,6),3,2),right(a1,2)))50

You can get 154.

Then you need to copy the formula or something. If you have any questions, please add them.

Double-click the cell and precede it with a single quotation mark in English.

My method is to take those numbers and turn them into constants, then modify them, and then turn them into scientific notations.

Very regular, A1 is your data, B1 is input.

left(a1,6)&"0"&right(a1,3)

Other formulas can be copied.

Liuyinde - Level 12 That's right. Haha, it seems that we have all neglected the basics!

Assuming that the data starts from A1 in column A, enter the following formula in B1 to pop it down.

PS: Click the mouse on the B1 cell, put it in the lower right corner of the B1 cell, when it is a cross, double-click the left button to fill it.

Haha, is it so troublesome to use, just change the first one and fill it downward.

You can use the replacement function as follows:

Materials required: Excel.

First, open the excel** file and enter the "Start" tab.

Second, click "Find & Select" under the Start option.

3. Click the "Replace" option in the pop-up drop-down menu.

4. After opening the Find and Replace window, enter "1" in the Find Content column, replace it with "Yes" in the column, and click "Replace All".

5. At this point, you can replace all 1s on the current page with yes.

1. Open the target file with the 2007 version of Excel software on the computer.

2. Then press the shortcut key "Ctrl+H" to bring up the "Replace and Replace" window.

5. Then click the "OK" button in the prompt box that appears.

6. After completing the above settings, you can complete the requirements of the questioner.

Ctrl+H, select "Cell Match" in the pop-up Find & Replace dialog box, otherwise 31 will become 3 yes.

Method 1:

Select a data region, and in Find and Replace, find:1

Replacement: Yes. Replace them all.

Method 2: Enter =if(a2=1,"Yes",a2)

With the conditional function if, 1 is returned as "yes".

See attached drawings for details.

With the replace function, select all the ranges to be replaced, and then replace with Find, Replace, 1 to Yes.