find and remove specific information from column

[lines_michael]

I hope that there is an answer to this.

I have a column 'AE' that contains the html code for ecommerce item descriptions. While importing/exporting back and forth with another program and my spreadsheet, the following was added all throughout the descriptions.

%0d%0a

In some places, it may be three or four times consecutively

%0d%0a%0d%0a%0d%0a%0d%0a

Is there a macro script I could run to simply remove this any time it occurs in this column? It is just showing up as text and I am sure in another program it was representing something other than text, probably a space or hard return. Regardless, I don't need it.

See example below:

<SPAN class=body>%0d%0a<P>The <STRONG>HNC-1&nbsp;</STRONG>brushed aluminum finish cover.</P>%0d%0a<P>Pictured bottom</P>%0d%0a<P>The <STRONG>HNC-1-P</STRONG> polished aluminum finish cover.</P>%0d%0a<P>Pictured top</P>%0d%0a<P>Both models are for the HND-3, HND-4 and HND-7 cruise control handles. These&nbsp;covers can also be used with the HND-1 by modifying the back side of the cover.</P></SPAN>

Thanks in advance.