what is comma deliniated

  • Thread starter Thread starter Guest
  • Start date Start date
Might look like this:

Name,Address,City
Anne Troy,34 South 3rd Street,Quakertown
M. Trend,123 Happy Street,Philadelphia
Mickey Mouse,16 Pluto Lane,Orlando

But, when you open a CSV (which defaults to Excel as the application of
choice on most machines that HAVE Excel), each comma tells it where a new
"column" begins. So this would create a 3-column Excel file, with data in
columns A, B, and C.
************
Anne Troy
www.OfficeArticles.com
 
It's a file (like a document) that doesn't have any formatting information
(like bold, or underline) or formulas (like =A1+B1)--just text. If you
opened a CSV (comma separated values) file in Word, you'd see:

Albert,14569,1234,3031234567,Green
Jennifer,8978,,8001234567,Purple

If you open the file in Excel, it separates each comma-separted value into a
separate column (if you run the "Import Text File" wizard):

A B C D E
1 Albert 14569 1234 3031234567 Green
2 Jennifer 8978 8001234567 Purple

A comma-delimited file is just a text file that can be read by lots of
different programs.
 

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

I want to format the cells in a table for currency... 2
Column of Numbers in xls to String of Numbers in txt 1
In excel there is something called "deliniate" (sp?). Where is it 3
highlighting part of string? 1
Count Commas in Cells 5
can i do a mass mailing from access? 1
Backing up Outlook Express Address Book 3
Importing to a contact subfolder with that has a custom form 1

Back
Top