Help

[elpaso]

I have a spreadsheet in which 900 cells contain a paragraph of HTML and text.

I need to delete this paragraph from every cell. How can I do it all at
once? Find and replace doesn't allow it.
Thanks!

This is the text:
<P align=center><STRONG><FONT color=#ff0000>Borderland
Exchange</FONT></STRONG></P>
<P align=center><STRONG><FONT color=#ff0000> We are Ebay's newest source for
sheet music, lesson books, instructional DVD's and songbooks. We offer an
extensive inventory of well known and hard to find methods for learning
guitar, bass, piano, drums, voice, mandolin, banjo and other instruments.
Thanks for shopping with us!</FONT></STRONG></P></FONT>
<P><FONT face=Arial></FONT> </P>
<P align=center><FONT face=Arial color=#009300>PLEASE REVIEW THESE POLICIES
BEFORE BIDDING:</FONT></P>
<P align=center><FONT face=Arial color=#009300><U>PLEASE ALLOW UP TO 14 DAYS
FOR DELIVERY.</U></FONT></P>
<P align=center><FONT face=Arial color=#009300><U>BACKORDERED ITEMS WILL BE
REFUNDED PROMPTLY.</U></FONT></P>
<P align=center><FONT face=Arial color=#009300><U>SHIPPING: BUYER PAYS $4.95
FLAT RATE. $12.50 INTERNATIONAL.</U></FONT></P>
<P align=center><FONT face=Arial color=#009300><U>RETURNS: RETURNS ACCEPTED
ONLY FOR PRODUCT DEFECTS.</U></FONT></P>
<P align=center><STRONG>. </STRONG></P>
<P align=center><STRONG></STRONG>Be sure to add me to your <A
href="http://cgi1.ebay.com/aw-cgi/eBayISA...erid=borderlandexchange&sspageName=DB:FavList"
target=_blank>favorites list</A>!<BR><BR></P>

 

[y_not]

I copy formulas into Word and use the find and replace function - seem
to work for me

Hope it helps

Ton

 

[elpaso]

Thanks Tony!