[SOLVED] Filter a list of data by removing only what is after a comma

**ctrc** · 01-23-2013, 09:01 PM

I have a list of data organized in row.
But each row has 2 sets of data separated by a comma.
I want to erase everything after the comma and just keep what is before.
See example bellow :

23455024 , 3621
23455024-- , 3621
22192760 , 3621
56-953-269 , 3621
30230101 , 3620
30230101-- , 3620
30-23-0101 , 3620
52-52-10 , 3620
411 - 389 - 981(3) , 3617
11389981-- , 3617
11389981 , 3619
0430 355 006 ( , 3618
30355006-- , 3618
12266706-- , 3615
34 492 298 , 3615

Any idea how to do that ?

Thank you !

**rylo** · 01-23-2013, 09:07 PM

Hi

Try a text to columns, with the separator as a comma. Make sure you have a blank column immediately to the right of the data, then you can delete that column and be left with the required data.

HTH

rylo