View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J_J[_2_] J_J[_2_] is offline
external usenet poster
 
Posts: 140
Default filtering CSV data

Hi,
I have 650 lines of data in CSV format in an excel sheet.
The lines are long and something like this:

Aaaaaa,"",Bbbbbb," ","bla bla", ..........
","sdfs d",.......
.....
....

I need to filter out the records like this

A B C
1 Aaaaa Bbbbbb ,
2 Cdfhdj Djkjds


Any code recommendation is much appriciated.
J_J