Hi David.

Our website is dtabase driven so the product pages are what Im trying to
change in the csv file. The reason I want to chage them to plain text is so I
can use the full description of the product in shopping comparison sites like
google, price grabber, price runner and ciao. These only accpet product
descriptions in plain text so all the html has to be removed.

Regards

Stuart

"David McRitchie" wrote:

Hi Stuart,
Each of your original cells was an entire formatted webpage, less pictures.
If you convert the text in one cell to plain text and bring it back into
Excel you are going to generated a lot empty lines due to paragraphs
which are necessary for humans to be able to read, and each
cell when brought back into Excel is going to take many cells (vertically).

You aren't going to be able read whole web pages in single cells no
matter what you do, so why not use links to the original web pages,
or to your archived copy of those web pages.

If you are trying to do some search on keywords on your machine
you could use Google Desktop on your machine, or Google to search
the site you want to search (limited to 32 words per search).

If you want the material back in their original cells, you will have to
use a macro like your first suggestion to remove the < and
everything in between (and replace with a space), it would be pretty
much unreadable, but it would match your initial post in this thread. .

Maybe if you stated the actual purpose, you might get suggestions
for other applications, because I don't see how storing this in Excel
is going to be efficient -- check the size of your Excel file.. .

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Stuart" wrote in message ...
Hi David.

Thanks for that, the only problem with that is it leaves lots of blank cells
when pasted back into excel. I've even tried saving the spreadsheet as csv
and text file to see if that would help when pasted back into excel. No luck
there. -- Any more ideas greatly accepted.