copying HTML table into Excel
 

I have a table in HTML format that I would like to copy into Excel. Because
the table contains various cells with a large amount of data (could have 10
lines of data within one cell), when copying into Excel, Excel treats each
line break as a different cell. Is there a way to perform this export/copy
so that Excel keeps the same "formatting" without treating each line break as
a different cell?

Thanks! (:

copying HTML table into Excel
 

Yes, there is a way to do this. I just got it figured out yesterday so it's
still fresh in my mind.

For the break, a CSS style property can be added to keep breaks in one cell.

<br style="mso-data-placement:same-cell;" /

I just would concatenate the break above in between the words. I hope this
helps.



"CherylH" wrote:

I have a table in HTML format that I would like to copy into Excel. Because
the table contains various cells with a large amount of data (could have 10
lines of data within one cell), when copying into Excel, Excel treats each
line break as a different cell. Is there a way to perform this export/copy
so that Excel keeps the same "formatting" without treating each line break as
a different cell?

Thanks! (: