Hi,
I have to transfer an HTML based text with bullets and statements into excel rows with bullets as a seprate column. Need help on how I can convert the HTML content to excel. I am putting down a sample for reference.
How Can I take the bullets out to a different column for indexation?
HTML Text -
"Business rules and listing rules of approved exchanges
23.—(1) Without limiting the generality of sections 16 and 45 —
<DL>
(a) the Authority may prescribe the matters that an approved exchange shall make provision for in the business rules or listing rules of the approved exchange; and</DL><DL>
(b) the approved exchange shall make provision for those matters in its business rules or listing rules, as the case may be.
(2) An approved exchange shall not make any amendment to its business rules or listing rules unless it complies with such requirements as the Authority may prescribe.
(3) In this Subdivision, any reference to an amendment to a business rule or listing rule shall be construed as a reference to a change to the scope of, or to any requirement, obligation or restriction under, the business rule or listing rule, as the case may be, whether the change is made by an alteration to the text of the rule or by any other notice issued by or on behalf of the approved exchange.
(4) Any approved exchange which contravenes subsection (1) or (2) shall be guilty of an offence and shall be liable on conviction to a fine not exceeding $150,000 and, in the case of a continuing offence, to a further fine not exceeding $15,000 for every day or part thereof during which the offence continues after conviction. "
I have to transfer an HTML based text with bullets and statements into excel rows with bullets as a seprate column. Need help on how I can convert the HTML content to excel. I am putting down a sample for reference.
How Can I take the bullets out to a different column for indexation?
HTML Text -
"Business rules and listing rules of approved exchanges
23.—(1) Without limiting the generality of sections 16 and 45 —
<DL>
(a) the Authority may prescribe the matters that an approved exchange shall make provision for in the business rules or listing rules of the approved exchange; and</DL><DL>
(b) the approved exchange shall make provision for those matters in its business rules or listing rules, as the case may be.
[1/2005]
</DL>(2) An approved exchange shall not make any amendment to its business rules or listing rules unless it complies with such requirements as the Authority may prescribe.
[1/2005]
(3) In this Subdivision, any reference to an amendment to a business rule or listing rule shall be construed as a reference to a change to the scope of, or to any requirement, obligation or restriction under, the business rule or listing rule, as the case may be, whether the change is made by an alteration to the text of the rule or by any other notice issued by or on behalf of the approved exchange.
[1/2005]
(4) Any approved exchange which contravenes subsection (1) or (2) shall be guilty of an offence and shall be liable on conviction to a fine not exceeding $150,000 and, in the case of a continuing offence, to a further fine not exceeding $15,000 for every day or part thereof during which the offence continues after conviction. "
