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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a table from Word 5
Pasting from Word Table 3
CSV->Excel Data Problem 1
Problem Cutting and Pasting from SQL Table to Excel Sheet 1
Is Paste Special HTML broken in Excel/Office 2007? 1
I want to copy cell from word that includes line breaks to excel 1
Copy text from word with returns into one cell 8
Pasting Word table cell with paragraph markers into single Excel c 1

Back
Top