cell coordinate label place (r,c)

X

XCell_Help

Add displayed information in a cell that has numbers within paranthesis like
"(2,-3)". Here is an example:
-3 -2 -1 0 1 2
3 |
2 |
1 ----(1, -2)
0
-1

There would be "axis" numbers on the edge of a "map". Every cell in the map
would display the location in the map as (row, col), like "(1,-2)" in the
example above. Thanks.
 
B

Bernie Deitrick

Put this formula into cell B2, and copy to fill your table:

="(" & $A2 & ", " & B$1 & ")"

I assumed that your labels are in row 1 and column A....


HTH,
Bernie
MS Excel MVP
 
Top