HTML & Excel

[Jim Pichler]

I am trying to open a ".csv" file that has HTML within
one field of the file.

I would like the HTML to just get inserted into one cell,
but when I open the file, it seems that excel
automatically starts to process the HTML and then render
it into the spreadsheet making it look kindof like a web
page.

Does anyone know how I can just get that HTML in one cell
on the ".csv" file open? I tried removing all the double
quotes and putting in a single quote, neither worked.

 

[J.E. McGimpsey]

Try changing the extension to .txt and using the Text Wizard to
bring in the columns as Text (click on the column in the third pane
and select the Text radio button).

 

[Jim Pichler]

Thanks for the suggestion. I tried doing that, when I
open the file, the text wizard does not pop up, it just
takes the data and starts to HTML render it. Do you know
if there is a way to make sure the text wizard pops up?

 

[J.E. McGimpsey]

one way

Data/Get external data/Import text file.