View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Remove html markup

Since you're fixing a .csv file, maybe excel isn't the best choice.

If you visit shareware.com, you can find lots of programs to clean up HTML
files.



Stuart wrote:

How do I remove HTML markup from and cell.

i.e.
<DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0
<TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most
dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR
<TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or
other raised surface, never leave your baby unattended even for a moment
</LI</UL</P</DIV

I want it to read:-

SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers
dimensions: 75 x 46cm When using a changing mat on a dresser or other
raised surface, never leave your baby unattended even for a moment

I am trying to change out website csv file into a froogle csv file but
without the HTML

Thanks in advance

Stuart


--

Dave Peterson