excell

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
 
J

JE McGimpsey

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving txt files with quotation mark delimiters 2
Cell content surrounded by quotes when saving as tab delimited for 2
*.csv format change if .xlt save as .csv in Excel 2007 1
Puzzling quotes around text 2
Converting a CSV file to an Excel file 3
Format changed if we save our own (.xlt) file as (.csv) in Excel 2 1
import .CSV file to XP EXcel 2003 worksheet, the seperator is com. 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Top