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

Aha..sorry
And I forget to tell that all data resides in the A:A column cells.
J_J

"J_J" wrote in message
...
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

try using the replace command under the edit menu. Turn on the macro
recorder and run it manually if you want code

--
Regards,
Tom Ogilvy

"J_J" wrote in message
...
Aha..sorry
And I forget to tell that all data resides in the A:A column cells.
J_J

"J_J" wrote in message
...
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

Sorry Tom, but I couldn't get your point.
I do not want to replace anything. All my data are on Sheet1 and resides in
column A:A.

With cell A1 what I need to do actually is :

get the first text from the left of first comma and put it to Sheet2 A1
get the text between the second and the third comma and put it to Sheet2 B1
get the emial address between the forth and fifth commas and put it to
Sheet2 C1

Then I need to repeat this process for all 650 lines.
Regards
J_J

"Tom Ogilvy" wrote in message
...
try using the replace command under the edit menu. Turn on the macro
recorder and run it manually if you want code

--
Regards,
Tom Ogilvy

"J_J" wrote in message
...
Aha..sorry
And I forget to tell that all data resides in the A:A column cells.
J_J

"J_J" wrote in message
...
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

Paste the column in Sheet2

Select column A in sheet2

do data=Text to columns, select comma as the delimiter

Delete the columns you don't want.

If you want code, turn on the macro recorder while you do it manually.

--
Regards,
Tom Ogilvy


"J_J" wrote in message
...
Sorry Tom, but I couldn't get your point.
I do not want to replace anything. All my data are on Sheet1 and resides
in
column A:A.

With cell A1 what I need to do actually is :

get the first text from the left of first comma and put it to Sheet2 A1
get the text between the second and the third comma and put it to Sheet2
B1
get the emial address between the forth and fifth commas and put it to
Sheet2 C1

Then I need to repeat this process for all 650 lines.
Regards
J_J

"Tom Ogilvy" wrote in message
...
try using the replace command under the edit menu. Turn on the macro
recorder and run it manually if you want code

--
Regards,
Tom Ogilvy

"J_J" wrote in message
...
Aha..sorry
And I forget to tell that all data resides in the A:A column cells.
J_J

"J_J" wrote in message
...
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

I got it this time.
Thanks a lot Tom.
J_J

"Tom Ogilvy" wrote in message
...
Paste the column in Sheet2

Select column A in sheet2

do data=Text to columns, select comma as the delimiter

Delete the columns you don't want.

If you want code, turn on the macro recorder while you do it manually.

--
Regards,
Tom Ogilvy


"J_J" wrote in message
...
Sorry Tom, but I couldn't get your point.
I do not want to replace anything. All my data are on Sheet1 and resides
in
column A:A.

With cell A1 what I need to do actually is :

get the first text from the left of first comma and put it to Sheet2 A1
get the text between the second and the third comma and put it to Sheet2
B1
get the emial address between the forth and fifth commas and put it to
Sheet2 C1

Then I need to repeat this process for all 650 lines.
Regards
J_J

"Tom Ogilvy" wrote in message
...
try using the replace command under the edit menu. Turn on the macro
recorder and run it manually if you want code

--
Regards,
Tom Ogilvy

"J_J" wrote in message
...
Aha..sorry
And I forget to tell that all data resides in the A:A column cells.
J_J

"J_J" wrote in message
...
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