View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Utahstew Utahstew is offline
external usenet poster
 
Posts: 6
Default Extract matching data from large data file (csv)

I need to extract data (the first three letters after the 2nd comma, and the
first 35 characters after the 7th comma) from a csv file (over 100,000 rows),
only after the 8th column matches a values in column A of my spreadsheet. The
two extracted data elements need to be stored in my worksheet in columns B
and C

Any help on this would be appreciated.