View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
GD1226, Captain Ahab, manface GD1226, Captain Ahab, manface is offline
external usenet poster
 
Posts: 7
Default Stripping HTML Tags out of cells

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!