Dear readers, do you sometimes find it particularly difficult to deal with excel data?Especially when you need to add a 1 to a large column of numbers, manually changing them one by one is simply too torturous!So how to add 1 in front of a number in batches in a simple and easy-to-use way?
1. Use the function function of excel
In Excel, you can:Use the function concat( ) or concatenate( ).to achieve the need to add 1 before the number. Suppose your numbers are in column A, starting from A2, you can enter this formula in cell B2:
concat(1,a2) or =concatenate(1, a2).
The meaning of this formula is to splice together the contents of the number 1 and A2 cells. Then, you can drag the formula to the entire column and you will have the effect of adding 1 in front of all the numbers. This method is simple and efficient, and is suitable for processing large amounts of data.
2. Use the formula function of excel
If you want to just show a 1 in front of a number, then you can use Excel's formula function.
1.Enter the formula "=1&Original cell number" in a blank cell, for example, "=1&a1".
2.Press enter, and you can see that the number in the cell has been preceded by 1.
3.Copy the formula of this cell to other cells that need to be modified, and you can add 1 to the number in front of it in batches.
How?Isn't it simple?Go and try it!If you have any questions or need further help, please feel free to leave me a message!I'll get back to you as soon as I can. At the same time, if you think this article is helpful to you, you are also welcome to follow, like and share it with your friends!