excel paste special to autocad entities

[david.marr]

I have searched all of the excel to AutoCAD entities topics and no one has addressed the issue I'm having. When I select my table info in excel, then go into AutoCAD and pastespec to AutoCAD entities, the table comes in, but the text in the table is A., wrong size, B., Wrong font, and C., the wrong color. I've tried setting excel to system font, and I set my desired table style as current, still get text that is the font and size from excel and the color 0,0,0 which is black. see attached screenshots.

[david.marr]

Not the clean cut solution I wanted, but it does work. still will not change the ' and " symbols to simplex, they stay as Arial but I can deal with that by having those symbols formatted into the cell and have the engineers that create the spreadsheet not use them. Thanks!

[MTovarF8BXV]

Hi David. I know is a late  reply but people are overcomplicating things. I use to have the same issue as you. The solution is simple:

Before inserting cells from Excel, check the system Variable PASTESPECMODE :

Value 0 (default): Keeps the Microsoft Excel formatting.
Value 1: Inherits the cell formatting defined in the AutoCAD table style.

This should solve your issue.