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