Can't edit attribute when inserting excel data that has 3 lines of data

[Findermb]

Hi there, I´m working with attribute blocks, and someone made an excel file with some data that has more than 1 line (That could be achieved pressing ALT+ENTER in excel) however when inserting the data with a coordinates MACRO, that attribute I can't edit those other lines of data, and when adding any information the other lines of data will be erased. Hope my hard english doesn't confuse you guys.

 

Attached you can find both the excel and the .dwg the data is not the same, but the block has the same attributes

 

EXAMPLE.xls

example.dwg

[steven-g]

Can you post the macro as well, it might help someone figure it out, (but using the ALT+ENTER in Excel probably introduces special formatting codes which don't work in Autocad) it would be better to have the information in seperate cells in the Excel sheet.

[Findermb]

Here is the MACRO, and I´m trying to separate the data, but there are over 15k of those blocks, and it will take me a long time to separate them manually.

 

Coordenadas.zip