Filtering a comma delimited file being imported into Excel

  • Thread starter Scott Calkins via OfficeKB.com
  • Start date
S

Scott Calkins via OfficeKB.com

Here is my issue. I have a comma delimited file that I import into a
spreadsheet that is rather large. (190,000 rows) Excel will only hold
65000 lines per sheet. Can anyone help me with a way to import this comma
file and have is spread over the 2-3 shhets it will need to hold it all?
Or as a backup a way to filter the data by one of the columns, ie only
inport row if b cell ="A"
 
M

Milly Staples [MVP - Outlook]

Try posting to an Excel news group - you will get a faster answer there.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, Scott Calkins via OfficeKB.com asked:

| Here is my issue. I have a comma delimited file that I import into a
| spreadsheet that is rather large. (190,000 rows) Excel will only hold
| 65000 lines per sheet. Can anyone help me with a way to import this
| comma file and have is spread over the 2-3 shhets it will need to
| hold it all? Or as a backup a way to filter the data by one of the
| columns, ie only inport row if b cell ="A"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import a comma delimited file & match records 3
comma delimited file in Word 2007?? 1
Importing a .pst file into Outlook Express 6.0 6
Paste comma delimited text into a spread sheet 5
Create a comma-delimited file to be opened in Excel 5
Importing Comma delimited file 2
Excel 2003 inserts quotes when saving SS as text and comma is pres 1
Convert Excel to comma delimited text 2

Top