CSV grabbing html

S

sherm50599

When I try and open a CSV (that has html in some of column fields), the csv opens this html. It shouldn't. How can I turn it off. I just want text to open.
 
D

David McRitchie

Don't understand what you have in the .csv file and what
you see or what happens that you don't want.

Try changing the file extension from .csv to .txt and then
open the file. Changing the file extension to .txt will allow
you do choose delimiter and then comma or whatever the
delimiter actually is and then telling Excel what format each column is.
---
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

sherm50599 said:
When I try and open a CSV (that has html in some of column fields), the csv opens this html. It shouldn't. How can I turn it off.
Click to expand...
I just want text to open.
 
Top