You eliminate the "Formula Too Long" error by making the formula
shorter!<bg

Seriously though, from your explanation, perhaps enter your "long
descriptions" into a datalist, and then, in the formula, refer to the
particular cell containing the proper text description.

If I've guessed wrong, post a formula or two.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"GD1226, Captain Ahab, manface" wrote in message
ups.com...
On Apr 8, 10:18 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Edit/ Replace:
Find what: <*
Replace with: [nothing]
--
David Biddulph

"GD1226, Captain Ahab, manface" wrote in
oglegroups.com...

I have an excel column with product descriptions that have random HTML
formatting in them. I need to take out all of the HTML in order to
meet new feed requirements.

How can I basically delete everything between < until it it hits and
then hits the next line & starts over?

Is there an easier way?

Thanks!

Wow, sometimes it's the simplest thing... I tried that one, but since
I have annoying long descriptions it returns an error "The Formula is
too Long" when I'm trying to Find Replace. I'm trying to do it in
TextPad now & import the descriptions back in. Thanks for your help!

If anyone knows how to fix the "Formula is Too Long" error, let me
know, otherwise thanks for your help!