Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mtrend
 
Posts: n/a
Default what is comma deliniated

Can someone please explain, in laymen's terms, what comma deliniated is?
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default 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   Report Post  
BekkiM
 
Posts: n/a
Default 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   Report Post  
George Nicholson
 
Posts: n/a
Default 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   Report Post  
Anne Troy
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing a part of a big comma delimited csv-file smari Excel Worksheet Functions 0 October 6th 05 02:32 PM
Show comma in data validation list? [email protected] Excel Discussion (Misc queries) 7 May 17th 05 02:07 AM
Comma is not visible in Excel DrNASA Excel Discussion (Misc queries) 1 March 10th 05 04:51 PM
Comma delimited question Carol Excel Discussion (Misc queries) 2 January 15th 05 11:32 AM
HELP - I need to change space delimited to comma? Mayer Excel Discussion (Misc queries) 1 December 18th 04 06:21 PM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"