excell

  • Thread starter Thread starter ABASSANETTI
  • Start date Start date
A

ABASSANETTI

ok, so i need to save this file to a comma delimited file. But I had t
create columns to change some info.. How do I get it back to comm
delimited? I tried save as .CSV but when I open it still has columns i
it
 
When you open a csv file - ANY csv file - in XL, it will by default
convert to "(have) columns in it". That's a function of how XL opens csv
files, not whether the file, as saved, "has columns in it".

The file saved as csv *IS* csv - no columns. Try opening it in another
application (e.g., Notepad).

To open a csv file in XL so that it's not separated into columns, use
the Data import Wizard (you may need to change the .csv to .txt first,
depending on your XL version).
 
Back
Top