Comma Delimited

A

ABASSANETTI

Is there anyway to change some of the fields in excel as a regular fil
(xls) then change it back to comma delimited? One of my clients want
his fields to be seperated by commas, not columns. But he needed th
date format changed and commas removed from money amounts. I don'
think you can do that when it's in comma delimited format can you
 
M

Myrna Larson

You can open the file in Excel (if it's an XLS file or if it's a CSV file),
make the changes, then File/Save As and be sure to select the CSV format.
 

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

Extracting Emails f 1
Excel 2003 inserts quotes when saving SS as text and comma is pres 1
Comma delimited bank info 4
comma delimited not seperating into columns 1
How do I save an excel spreadsheet as a comma-delimited ASCII file 3
Converting from CSV to Tab Delimited 2
How to produce comma-delimited and quoted text file from Excel? 1
Best way to format a flat file that Excel will load properly? 8

Top