CAD Text Files to Excel

[Anonymous]

When I import CAD text file to Excel not all info comes in as it should. Block of text comes in where I tell it to but other blocks of text come in to the far right. CAD floor plans and blocks are from client. There are a bunch of <> imported to spreadsheet. Is there an easy fix? Over room name/number 1500 blocks. See attached Excel sheet.

Thanks.

[Alfred.NESWADBA]

Hi,

>> but other blocks of text come in to the far right

Because the columns inside your text file have names, and an attribute "NAME1" of block "KA_SPACEOBJECTS" can't be saved in column A which is the attribute "NAME1" of block "KA_ROOMNAME".

As you used command _ATTEXT this command you can only get this type/structure of columns.

However, you might try a different command _DATAEXTRACTION which creates a list which might match better your needs.

- alfred -