ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Open HTML in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/21729-open-html-excel.html)

[email protected]

Open HTML in Excel
 
when opening the following html in Excel, the first <td actully
was converted into 3 excel cell. is there any way I can force them into
one cell? so that each <td got converted exactly into one cell no
matter what html text inside <td



<table
<tr
<td
Column 1
<li
item #1
<li
item #2
</td
<td
Column 2
</td
</tr
</table


Amedee Van Gasse

shared this with us in microsoft.public.excel.misc:

when opening the following html in Excel, the first <td actully
was converted into 3 excel cell. is there any way I can force them
into one cell? so that each <td got converted exactly into one cell
no matter what html text inside <td



<table
<tr
<td
Column 1
<li
item #1
<li
item #2
</td
<td
Column 2
</td
</tr
</table


No, you can't.
Because the <li is a paragraph-type element.
Anyway your HTML is totally invalid. <li needs a <ul or <ol
container, and also a closing </li tag:

<table
<tr
<td
Column 1
<ul
<liitem #1</li
<liitem #2</li
</ul
</td
<td
Column 2
</td
</tr
</table

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html
How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
o-answers.html


All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com