copying HTML table into Excel

  • Thread starter Thread starter CherylH
  • Start date Start date
C

CherylH

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! (:
 
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.
 
Back
Top