how to represent x,y coordinate in single column?

C

co-ordinate

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?
 
J

JoeU2004

co-ordinate said:
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?
Click to expand...

Is this what you want:

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

Jacob Skaria

Joe, a small typo correction...

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Adding a big matrix in Word 2013 5
Style names lost when copy/pasting 6
Histogram/Frecuency for Multiple Response Questions 1
Visio 2016 - Single exterior wall with multiple thicknesses 1
Permutations andText to column problem 6
Spreadsheet - Deleting Duplicate Records - Self Checking 1
Listing data from an array using column and row headers 1

Top