View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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 ")"