software

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:
lt;P align=centergt;lt;STRONGgt;lt;FONT color=#ff0000gt;Borderland
Exchangelt;/FONTgt;lt;/STRONGgt;lt;/Pgt;
lt;P align=centergt;lt;STRONGgt;lt;FONT color=#ff0000gt; 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!lt;/FONTgt;lt;/STRONGgt;lt;/Pgt;lt;/FONTgt;
lt;Pgt;lt;FONT face=Arialgt;lt;/FONTgt; lt;/Pgt;
lt;P align=centergt;lt;FONT face=Arial color=#009300gt;PLEASE REVIEW THESE POLICIES
BEFORE BIDDING:lt;/FONTgt;lt;/Pgt;
lt;P align=centergt;lt;FONT face=Arial color=#009300gt;lt;Ugt;PLEASE ALLOW UP TO 14 DAYS
FOR DELIVERY.lt;/Ugt;lt;/FONTgt;lt;/Pgt;
lt;P align=centergt;lt;FONT face=Arial color=#009300gt;lt;Ugt;BACKORDERED ITEMS WILL BE
REFUNDED PROMPTLY.lt;/Ugt;lt;/FONTgt;lt;/Pgt;
lt;P align=centergt;lt;FONT face=Arial color=#009300gt;lt;Ugt;SHIPPING: BUYER PAYS $4.95
FLAT RATE. $12.50 INTERNATIONAL.lt;/Ugt;lt;/FONTgt;lt;/Pgt;
lt;P align=centergt;lt;FONT face=Arial color=#009300gt;lt;Ugt;RETURNS: RETURNS ACCEPTED
ONLY FOR PRODUCT DEFECTS.lt;/Ugt;lt;/FONTgt;lt;/Pgt;
lt;P align=centergt;lt;STRONGgt;. lt;/STRONGgt;lt;/Pgt;
lt;P align=centergt;lt;STRONGgt;lt;/STRONGgt;Be sure to add me to your lt;A
href=quot;cgi1.ebay.com/aw-cgi/eBayISAPI.dll?AcceptSavedSelleramp;sellerid=borderlan dexchangeamp;sspageName=DB:FavListquot;
target=_blankgt;favorites listlt;/Agt;!lt;BRgt;lt;BRgt;lt;/Pgt;


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: www.excelforum.com/member.php...oamp;userid=19947
View this thread: www.excelforum.com/showthread...hreadid=525122Thanks Tony!

quot;y_notquot; wrote:

gt;
gt; I copy formulas into Word and use the find and replace function - seems
gt; to work for me
gt;
gt; Hope it helps
gt;
gt; Tony
gt;
gt;
gt; --
gt; y_not
gt; ------------------------------------------------------------------------
gt; y_not's Profile: www.excelforum.com/member.php...oamp;userid=19947
gt; View this thread: www.excelforum.com/showthread...hreadid=525122
gt;
gt;