Hi there,
I am mass updating my website using an Excel template. I am trying to extract text from all cells. An example of the text in my cell at the moment is:
<ul>
<li>Like a 11oz mug but just without a handle makes it perfect for use either as a cup or a storage pot</li>
<li>Measures 9.5cm x 8cm x 8cm</li>
<li>Pure white in colour it enhances vibrant colours</li>
<li>Comes with black inner colour. Also available with dark blue inner and red inner.</li>
<li>Tried and tested for both photo images as well as text</li>
<li>100% dishwasher proof</li>
</ul>
I am trying to extract the red text. The sentence itself is on different lines in each cell but I have made sure that every instance of this is the same in terms of being between "<li>" and "</li>" and spacing etc. Of course the dimensions for each product will be different so I need to find a way to extract this.
If I can do it without VBA that will be good as I do not know how to use that but if not then will try and use it.
All of this text is in Column F for a bout 1100 rows.
Hope that helps and hope someone can help!
Kind regards,
N
I am mass updating my website using an Excel template. I am trying to extract text from all cells. An example of the text in my cell at the moment is:
<ul>
<li>Like a 11oz mug but just without a handle makes it perfect for use either as a cup or a storage pot</li>
<li>Measures 9.5cm x 8cm x 8cm</li>
<li>Pure white in colour it enhances vibrant colours</li>
<li>Comes with black inner colour. Also available with dark blue inner and red inner.</li>
<li>Tried and tested for both photo images as well as text</li>
<li>100% dishwasher proof</li>
</ul>
I am trying to extract the red text. The sentence itself is on different lines in each cell but I have made sure that every instance of this is the same in terms of being between "<li>" and "</li>" and spacing etc. Of course the dimensions for each product will be different so I need to find a way to extract this.
If I can do it without VBA that will be good as I do not know how to use that but if not then will try and use it.
All of this text is in Column F for a bout 1100 rows.
Hope that helps and hope someone can help!
Kind regards,
N