Extract From Text After Comma Mark

[muhammad susanto]

hi all...

i want to extract text from left after second mark "comma" :
the clue is red font comma mark..

data	expected result/after formula
Jl. Teratai No. 242, Pekanbaru,Pekanbaru,PEKAN BARU KOTA,PEKAN BARU,R I A U	Jl. Teratai No. 242, Pekanbaru
Jalan Yos Sudarso Nomor 588 Rumbai Pekanbaru,Pekanbaru,PEKAN BARU KOTA,PEKAN BARU,R I A U	Jalan Yos Sudarso Nomor 588 Rumbai Pekanbaru,Pekanbaru
Jl. Tg. Batu No. 107, Pekanbaru,Pekanbaru,PEKAN BARU KOTA,PEKAN BARU,R I A U	Jl. Tg. Batu No. 107, Pekanbaru
Jalan Budi Luhur RT.01/10, Kulim,Tenayan Raya,,,	Jalan Budi Luhur RT.01/10, Kulim

<tbody>
</tbody>

any assistance much appreciated,,

m.susanto

 

[Comfy]

Here's one way:

Excel 2010
	A	B
1	data
2	Jl. Teratai No. 242, Pekanbaru,Pekanbaru,PEKAN BARU KOTA,PEKAN BARU,R I A U	Jl. Teratai No. 242, Pekanbaru
3	Jalan Yos Sudarso Nomor 588 Rumbai Pekanbaru,Pekanbaru,PEKAN BARU KOTA,PEKAN BARU,R I A U	Jalan Yos Sudarso Nomor 588 Rumbai Pekanbaru,Pekanbaru
4	Jl. Tg. Batu No. 107, Pekanbaru,Pekanbaru,PEKAN BARU KOTA,PEKAN BARU,R I A U	Jl. Tg. Batu No. 107, Pekanbaru
5	Jalan Budi Luhur RT.01/10, Kulim,Tenayan Raya,,,	Jalan Budi Luhur RT.01/10, Kulim
Sheet1

Cell Formulas
Range	Formula
B2	=TRIM(LEFT(SUBSTITUTE(A2,",",REPT(" ",255),2),255))

 

[XOR LX]

Hi.

=LEFT(A2,FIND("ξ",SUBSTITUTE(A2,",","ξ",2))-1)

Regards