How to input the formula of merging two columns of data into coordinate points in excel

You can use a custom formula to merge two columns of data into coordinate points, and you can refer to the steps below for details.

1. Open Office first

Excel office software.

The demo is available in Office Home and Student 2016, but other versions are acceptable.

2. Enter a number of numbers in column B and column C as the demonstration data, and enter "coordinates" in cell D2, and add shading to the data area at the same time, which can make the results more intuitive and clear.

3. Enter the formula "=" in cell 3"("&b3&","&c3&")"The function of the formula is to splice the values of the two columns of AB, and at the same time add parentheses and commas in the middle to the left and right sides to splice into a coordinate form, and the coordinate form in the formula can be changed according to actual needs.

4. After the input formula is completed, click Enter, you can find that the data of the two columns of AB has been successfully spliced, and the correct coordinates have been displayed in the coordinate column.

5. Select cell D3, move the mouse to the small square at the bottom right, and then use the filling handle to pull down, you can find that all the data in the two columns of AB have been spliced into coordinates and the result is correct.

1. First of all, enter two columns of data in Excel**, which need to be merged into a coordinate point style.

2. Enter the formula =: in cell C1"("&a1&","&b1&")", non-numeric characters need to be added in double quotation marks.

3. Click Enter to see the form of combining A1 and B1 to form coordinates.

4. Click the drop-down formula to merge coordinates according to column A and column B data.

The method of input.

1、excel

The two columns of data are combined into coordinates, often in two forms, (x,y) or x,y, depending on the need.

Suppose a column is an x value, b column is a y value, and c column is a coordinate value. Column C has the following formula:

c1="("&a1&","&b1&")"

Or, c1=a1&","&b1

The number of coordinates in column C is the same as that in column A and column B.

2. If you control the number of digits for the coordinates of column C, such as 3 digits, you need to use the round function, which can be used by the following formula: or.

Tools: Microsoft Excel 20101, open the Excel document, first create a new column after the XY column, and Huikuan as the column to store the X,Y coordinates.

2. Enter the formula in the first row of the x and y columns, =b2&", c2, carriage return. For the usage of &, please refer to "Excel2013 How to Merge Cell Contents".

3. The first row gets 561,25 by the formula, move the mouse to the lower right corner of this cell, when the mouse becomes "+", drag the mouse down, copy the formula to other cells in the first column.

4. You can get the coordinates in the form of x and y.

Enter = in C1"("&a1&", "&b1&")"

with"It's all in English format.

Copy the formula (select C1, move the mouse to the bottom right corner of C1, and double-click the "+".)