Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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? |
#3
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |