Kneeling to the master: How to use excel

Kneeling Master: How to export excel CAD data to each other

CAD can realize these two functions, as follows:

Import CAD coordinate data into excel:

Use a polyline in CAD to trace the points you want to output one by one, then select the polyline, enter "li" in the dialog box and press Enter, the coordinates of the points will appear. Copy and paste them in a In notepad, save. Now you open excel, use excel to open the notepad you just saved, select fixed width, adjust the column width, and you are done. Finally, use the edit and replace function in excel to replace the useless x= y=. Enough.

Import the coordinate data in excel into CAD:

First copy the coordinate data in excel to a notepad. The data format in the notepad is:

y,x

y,x

...

For example: 36071283.00,3248453.00

(Note that it is y first, then x because the coordinates in CAD are opposite to the x and y coordinates printed out by GPS)

After adjusting the format, open CAD, first select the polyline function, then copy the data in Notepad to the dialog box in CAD, press Enter, and you will see that CAD draws it according to your coordinates A broken line.

Go and try it!

Kneel down, excel master!

Please format the first and second rows as text (select rows 1 and 2, right-click - "Format Cells" - "Number" - "Text" - "OK" )

Suppose the data is as shown:

Change the formula =IF(A1=＂＂,＂＂,IF(A2=＂＂,＂＂,LEFT(A1,(FIND(＂/＂,A1)-1)) LEFT(A2,(FIND( ＂/＂,A2)-1))&＂/＂&MID(A1,FIND(＂/＂,A1) 1,LEN(A1)) MID(A2,FIND(＂/＂,A2) 1,LEN(A2 )))) Copy and paste into the "A3" cell, aim the cursor at the lower right corner, hold down the left button and drag to the right, the effect is as shown below:

If it doesn’t look good, the formula can be simplified to:

=LEFT(H1,(FIND(＂/＂,H1)-1)) LEFT(H2,(FIND(＂/＂,H2)-1))&＂/＂&MID(H1,FIND(＂/ ",H1) 1,LEN(H1)) MID(H2,FIND("/＂,H2) 1,LEN(H2))

The above is the detailed content of Kneeling to the master: How to use excel. For more information, please follow other related articles on the PHP Chinese website!