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=#ff0000Borderland
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=#009300PLEASE REVIEW THESE POLICIES
BEFORE BIDDING:</FONT</P
<P align=center<FONT face=Arial color=#009300<UPLEASE ALLOW UP TO 14 DAYS
FOR DELIVERY.</U</FONT</P
<P align=center<FONT face=Arial color=#009300<UBACKORDERED ITEMS WILL BE
REFUNDED PROMPTLY.</U</FONT</P
<P align=center<FONT face=Arial color=#009300<USHIPPING: BUYER PAYS $4.95
FLAT RATE. $12.50 INTERNATIONAL.</U</FONT</P
<P align=center<FONT face=Arial color=#009300<URETURNS: RETURNS ACCEPTED
ONLY FOR PRODUCT DEFECTS.</U</FONT</P
<P align=center<STRONG. </STRONG</P
<P align=center<STRONG</STRONGBe sure to add me to your <A
href="http://cgi1.ebay.com/aw-cgi/eBayISAPI.dll?AcceptSavedSeller&sellerid=borderlan dexchange&sspageName=DB:FavList"
target=_blankfavorites list</A!<BR<BR</P

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

Hope it helps

Tony


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=525122

Thanks Tony!

"y_not" wrote:


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

Hope it helps

Tony


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=525122