I'm trying to copy a range of cells from an Excel 2010 spreadsheet and paste them into a table in AutoCAD LT 2016. My problem is Excel applies formatting information to each of the cells. AutoCAD uses this formatting to override its styles on a cell-by-cell basis, so my table doesn't conform to design standards.
What I would like to do is remove all formatting from the Excel file as could be done in Excel <97. Failing that, if there was a clipboard utility that stripped formatting from the table (but left cell merge information) that would be an acceptable alternative.
I've tried cutting and pasting from Google Docs and LibreOffice, but AutoCAD interprets their clipboard objects differently, and doesn't create a table from the data when pasted.
I've seen some LISP routines that will scrub this formatting within AutoCAD, but since my employer runs LT, these aren't available to me.
Any ideas?
copy
,paste without formatting
on an empty sheet,copy
again andpaste
into AutoCAD?