Remove <IMG> with a regular expression & macro

Hello

I have a column with html code, I would like to delete all pictures <IMG> tag example:
<img alt="iPhone 5 32GB" src="http://img.domaine.com/images/upload/SKU45254755/20111219150204368.jpg" />

I think it is possibe with a macro using regular expressions.

Can you help me please?

Is this an excel file with rows of html code like the one you quote?

If So a simple formula would get rid of the line.

Or are you saying that you want the row deleted?

No i have html code in cell, i want to keep it but i want to delete IMG balise exemple

Description:<BR>Material: Cotton+Polyester<BR>Color: black,dark grey,camel<BR><BR>&nbsp;Package Include:<BR>1* Dress Shirt<BR><BR>Details in size: <TABLE border="10"> <TBODY> <TR> <TD> US&nbsp;Size</TD> <TD> S</TD> <TD> M</TD> <TD> L</TD> <TD> XL</TD></TR> <TR> <TD> Tag&nbsp;Size</TD> <TD> M</TD> <TD> L</TD> <TD> XL</TD> <TD> XXL</TD></TR> <TR> <TD> Shoulder</TD> <TD> 43cm(16.9")&nbsp;</TD> <TD> 44cm(17.3")&nbsp;</TD> <TD> 45cm(17.7")&nbsp;</TD> <TD> 46cm(18.1")&nbsp;</TD></TR> <TR> <TD> Bust</TD> <TD> 101cm(39.7")&nbsp;</TD> <TD> 102cm(40.1")&nbsp;</TD> <TD> 105cm(41.3")&nbsp;</TD> <TD> 106cm(41.7")&nbsp;</TD></TR> <TR> <TD> Sleeve&nbsp;Length</TD> <TD> 60cm(23.6")&nbsp;</TD> <TD> 62cm(24.4")&nbsp;</TD> <TD> 64cm(25.1")&nbsp;</TD> <TD> 66cm(25.9")&nbsp;</TD></TR> <TR> <TD> &nbsp;Length</TD> <TD> 59.5cm(23.4")&nbsp;</TD> <TD> 62cm(24.4")&nbsp;</TD> <TD> 63cm(24.8")&nbsp;</TD> <TD> 69cm(27.2")</TD></TR></TBODY></TABLE> <BR>Attention: Size may be 2cm/1 inch inaccuracy due to hand measure and the size on tags is for Asian; Color may be a little different due to monitor,thanks for your understanding!<BR><BR>More details:<BR><IMG alt="" src="http://img.banggood.com/images/upload/2012/xiemeijuan/SKU026985_1.jpg"><BR><BR><IMG alt="" src="http://img.banggood.com/images/upload/2012/xiemeijuan/SKU026985_2.jpg"><BR><BR><IMG alt="" src="http://img.banggood.com/images/upload/2012/xiemeijuan/SKU026985_5.jpg"><BR><BR><IMG alt="" src="http://img.banggood.com/images/upload/2012/xiemeijuan/SKU026985_3.jpg">

If this is not how you wanted, need to see your data in workbook with your desired result.

Please Login or Register  to view this content.

Thanks it works!

Good, can you mark this thread as "Solved"?