Import Text from Excel to AutoCAD (Excel formula for Creating Text in AutoCAD)

This session is about creating Text in AutoCAD using data present in an Excel sheet. Using a simple Excel formula we can create 1000s of Text Objects within no time.

Topics Discussed are :

1. Excel Formula for creating Text in AutoCAD
2. Controlling Height and Rotation using Cell References
3. Importing Finished Roads and Original Ground Levels into an AutoCAD drawing
4. A macro for extracting details of all those Text Objects (X,Y,Z Coordinates and Text) present in an AutoCAD drawing

Download XLnCAD's Workbook

Import X Y Z Coordinates from Excel to AutoCAD (Create Points using X Y ...

This session is about creating points in AutoCAD using X, Y, Z Coordinates (Easting, Northing, Reduced Levels) present in an Excel sheet.

Methods explained are :

1. Using the Concatenate Function in Excel

2. Using '&' Operator

3. Using Command Alias for Point

#XYZfromExcelToAutoCAD #PointInAutoCAD #ExcelToAutoCAD

Download XL n CAD's Workbook

10 Methods to 'Paste Value' in MS Excel

This video discusses 10 methods for Copying and Pasting values in Excel

Methods explained are :

1. Using Right Mouse Button
2. Paste Special Dialog Box from Right Click
3. Paste Icon from Right Click
4. Paste Special in Home Tab
5. Alt, E, S, V (Shortcut 1)
6. Crtl + Alt, V (Shortcut 2)
7. Macro for Paste Values
8. Macro for Converting Formulas into Values
9. Using Power Query
10. Converting Formula into Value using F2 and F9

#PasteValuesInExcel #PasteValuesShortCut #PasteValues