Hello,
I have an excel sheet with about a thousand text cells.
Many of them contain errors which I normally "Find and Replace."
However, these entries are about twenty lines long, and though I can find them, I can not replace them in bulk. It tells me that the "Formula is too long"
An example of a cell entry is provided below:
I need to replace Europe? with Europe" and I need to replace $11.00 with $8.00
<font face="Verdana" color="#484b38" size="2em">
Waterford Full Lead Crystal Waterford Lismore Bridal Wedding Knife. Hand washing recommended. Made in Ireland. This piece is 13 inches in Length. The item number is
7203180024 and it retails for $119.00. It is brand new and
comes in original box with a certificate of authenticity.<p>
When the brothers George and William Penrose founded the Waterford Glass House
in 1783, they made a bold promise - to make crystal in "as fine a quality as any
in Europe? in the most elegant style." They had in hand the old secrets of
mingling minerals and glass to create a crystal of beautiful and mysterious
qualities and radiated a distinctive, silvery white brilliance, which Waterford
Crystal's artists enhanced with deeply - cut ornamentation that gave the
finished pieces a vivacious sparkle.<p>
<b>Terms and Conditions:</b><br>
United States Residents: Please add $11.00 for shipping and insurance.<br>
International Residents: Please email us for a shipping quote.<br>
Please read our Customer Service Policy at the bottom of the page for information on shipping, combined shipping and returns.</font>
I looked though these forums and found similar problems, but no solution yet.
Is there perhaps an add in software that would solve this?
Any help would be greatly appreciated!
Bookmarks