deleting all html from excel files

H

Helen

Is there a way to delete all HTML coding from Excel files
(ex. br, table, font commands) while keeping the text in
between the commands? I have over 3000 rows, each of which
has some HTML coding that I must get rid of.
 
D

Dreamboat

Have you tried being creative with find/replace (using nothing in the replace with)?

If we could see the syntax of your data, we could probably help easier.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Anne Troy
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
 
H

Helen

Unfortunately, I do not know how to write macros.

When I use the Replace command, I get a message that 'The
formula is too long'.

I have about 3000 rows with 10 columns. Here is an
example of part of one cell. (I've replaced some of the
HTML commands so they won't convert) I've also just
noticed another problem: how can I get rid of forced line
breaks and excess spaces? I need everything in one
paragraph

Thanks!

"[font face="arial, helvetica" size="2"]Command &amp;
Conquer Generals puts your trigger finger on the pulse of
modern warfare.[br] Choose a General in control of
massive armies of bleeding-edge military weaponry across
a globe teetering on the brink of Armageddon.[br]Command
either the mighty U.S. Army, the Chinese war machine or
the resourceful Global Liberation Army, each packed with
high-tech arsenals ready to deliver unprecedented
firepower on land or in the skies.[br][br][br]Product
Features
[ul][li]modern warfare - unleash[/li][/ul]
 
D

Dave Peterson

I'm not sure if this'll work for you, but there are shareware programs that will
remove html code from files. It would be external to excel.

http://shareware.search.com/search?cat=237&tag=ex.sa.fd.srch.sa_win&q=remove+html
(one line in your browser)


Unfortunately, I do not know how to write macros.

When I use the Replace command, I get a message that 'The
formula is too long'.

I have about 3000 rows with 10 columns. Here is an
example of part of one cell. (I've replaced some of the
HTML commands so they won't convert) I've also just
noticed another problem: how can I get rid of forced line
breaks and excess spaces? I need everything in one
paragraph

Thanks!

"[font face="arial, helvetica" size="2"]Command &amp;
Conquer Generals puts your trigger finger on the pulse of
modern warfare.[br] Choose a General in control of
massive armies of bleeding-edge military weaponry across
a globe teetering on the brink of Armageddon.[br]Command
either the mighty U.S. Army, the Chinese war machine or
the resourceful Global Liberation Army, each packed with
high-tech arsenals ready to deliver unprecedented
firepower on land or in the skies.[br][br][br]Product
Features
[ul][li]modern warfare - unleash[/li][/ul]
Click to expand...
 
D

Dreamboat

Try only replacing pieces at a time. Once you've figured out exactly what you need to find and replace, you can record a macro (I don't write them either). Here's how to record a macro, and some other stuff that will help you
www.theofficeexperts.com/officevba.htm and click on Excel macros

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*-
Hope this helps
Anne Tro
Author: Dreamboat on Wor
Email: Dreamboat*at*Piersontech.co
Web: www.TheOfficeExperts.com
 
D

Dave Peterson

The bad news is that in another thread, Helen said that she's getting a formula
too long after she tries the edit|replace.
 
Top