Hi
I have a set of data with HTML product descriptions. as below
<p>Aluminium oxide</p><p>For grinding, sanding and smoothing</p><ul><li>Suitable for metal, wood and plastic</li><li>Removes rust and paint</li><li>For sheet metal and car body work</li><li>No backing pad required</li></ul><p>Suitable for all makes of 115mm angle grinders.<br>Aluminium oxide construction.<br>The conical shape provides an excellent angle for contour and edge grinding.<br>Ideal for heavy grinding on ferrous metals as well as hard woods among many other applications.<br>Aluminium oxide flap discs are specially designed to be used with angle grinders for grinding flat surfaces.<br>Features a depressed centre and are primarily used on alloy steel and low alloy steel</p><p>Achieves a longer life when compared to resin fibre discs.</p><ul><li>Diameter: 115mm ( 4½" )</li><li>Bore / Arbor Size: 22.2mm</li></ul><p>Buy 100 for a bulk discount!</p>
this is in column H.
I want this to be split at each new paragraph or bullet point into columns I, J, K .... etc.
and then repeat for the row below.
any advice appreciated.
Thanks
Bookmarks