Home |
Search |
Today's Posts |
#1
|
|||
|
|||
what is comma deliniated
Can someone please explain, in laymen's terms, what comma deliniated is?
|
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing a part of a big comma delimited csv-file | Excel Worksheet Functions | |||
Show comma in data validation list? | Excel Discussion (Misc queries) | |||
Comma is not visible in Excel | Excel Discussion (Misc queries) | |||
Comma delimited question | Excel Discussion (Misc queries) | |||
HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) |