copying HTML table into Excel

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! :)
 
M

megbou

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

Pasting from Word Table 3
Is Paste Special HTML broken in Excel/Office 2007? 1
Copying a table from Word 5
Bring in Word table 2
Linking a cel from Excel to a Cell in a Word table 3
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) 2
Too much data in one cell 2
How DO I Increase The Excel Cell Comment Data Capacity? 1

Top