Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a csv file
apx 500 fields in double quotes, separated by commas. Each "value" mwill vary in length There may be many rows of data like this in the file, each with the same number of values Blank values are represented by 2 double quotes Example: "Name","Address","Phone","Gender",etc.etc.etc. etc "Mary","123 Any Street","555-1212","F" "Bill","PO Box 1","","M" "Darth","","","" What I want to do is bring in each field from row 1 and put it in a spreadsheet going down say 500 rows in column A. Then move to the next data row and insert each of those fields into column B. Like this: "Mary" "123 Any Street" "555-1212" "F" etc etc etc etc I know READLINE will read a whole line, but I haven't found a way to read a "value". Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sort or compare data from 2 different spreadsheet columns | New Users to Excel | |||
How do I rotate data in a spreadsheet so that rows become columns? | Excel Discussion (Misc queries) | |||
Read/Write data to/from text files from a spreadsheet. | Excel Programming | |||
cboBox to read data from a spreadsheet Range | Excel Programming | |||
cboBox to read data from a spreadsheet Range | Excel Programming |