what is comma deliniated
 

Can someone please explain, in laymen's terms, what comma deliniated is?

what is comma deliniated
 

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

"mtrend" wrote in message
...
Can someone please explain, in laymen's terms, what comma deliniated is?

what is comma deliniated
 

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.

"mtrend" wrote:

Can someone please explain, in laymen's terms, what comma deliniated is?

what is comma deliniated
 

c'mon, everyone knows Mickey lives in Toontown.

--
George Nicholson

Remove 'Junk' from return address.

"Anne Troy" wrote in message
...
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

"mtrend" wrote in message
...
Can someone please explain, in laymen's terms, what comma deliniated is?

what is comma deliniated
 

My bad. Hopefully the OP will recognize that it's bad data. :)
************
Anne Troy
www.OfficeArticles.com

"George Nicholson" wrote in message
...
c'mon, everyone knows Mickey lives in Toontown.

--
George Nicholson

Remove 'Junk' from return address.

"Anne Troy" wrote in message
...
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

"mtrend" wrote in message
...
Can someone please explain, in laymen's terms, what comma deliniated is?