Automatic line generation

[ctnycc]

Good Day,

I have a spreadsheet with grid coordinates and was wondering if anyone can help with a routine to assist in producing lines for each of these.  An example of the layout in the spreadsheet is attached.   I am using this to highlight onthe map the locations of highway assets.

Any help or suggestions welcome

Thanks in advance

Regards

COlin

[ВeekeeCZ]

Use don't need routine. Make simple script in excel. 

Use this formula 

US (comma delimiter)
=CONCATENATE(E2," ",A2,",",B2," ",C2,",",D2," ")

Internetional (semicolon delimiter)
=CONCATENATE(E2;" ";A2;",";B2;" ";C2;",";D2;" ")

The point is get something like this:
LINE x1,y1 x2,y2
LINE x3,y3 x4,y4

...and paste the result column into autocad command line.

[ctnycc · Accepted solution]

Hi BeeKeeCZ, i started looking at the first part using excel, second part looks promising, but i don't want the lines joined up, need to break the line command up after each line.

[ВeekeeCZ · Accepted solution]

I don't think is needed. If you paste whole colomn, then the paragraph mark does that. Otherwise add one more space at the end of formula.