how to represent x,y coordinate in single column?
 

As i want two cell data in new cell separated by comma, which we can use as a
co-ordinate (x,y) in other CAD software. Can somebody help me in this issue?

how to represent x,y coordinate in single column?
 

"co-ordinate" wrote:
As i want two cell data in new cell separated by comma, which we can use
as a
co-ordinate (x,y) in other CAD software. Can somebody help me in this
issue?

Is this what you want:

="(" & X1 & "," Y1 ")"

how to represent x,y coordinate in single column?
 

Joe, a small typo correction...

="(" & X1 & "," Y1 & ")"

If this post helps click Yes
---------------
Jacob Skaria


"JoeU2004" wrote:

"co-ordinate" wrote:
As i want two cell data in new cell separated by comma, which we can use
as a
co-ordinate (x,y) in other CAD software. Can somebody help me in this
issue?

Is this what you want:

="(" & X1 & "," Y1 ")"

how to represent x,y coordinate in single column?
 

Oops

="(" & X1 & "," & Y1 & ")"
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Joe, a small typo correction...

="(" & X1 & "," Y1 & ")"

If this post helps click Yes
---------------
Jacob Skaria


"JoeU2004" wrote:

"co-ordinate" wrote:
As i want two cell data in new cell separated by comma, which we can use
as a
co-ordinate (x,y) in other CAD software. Can somebody help me in this
issue?

Is this what you want:

="(" & X1 & "," Y1 ")"