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..

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]data[/TD]
[TD]expected result/after formula[/TD]
[/TR]
[TR]
[TD]Jl. Teratai No. 242, Pekanbaru,Pekanbaru,PEKAN BARU KOTA,PEKAN BARU,R I A U[/TD]
[TD]Jl. Teratai No. 242, Pekanbaru[/TD]
[/TR]
[TR]
[TD]Jalan Yos Sudarso Nomor 588 Rumbai Pekanbaru,Pekanbaru,PEKAN BARU KOTA,PEKAN BARU,R I A U[/TD]
[TD]Jalan Yos Sudarso Nomor 588 Rumbai Pekanbaru,Pekanbaru[/TD]
[/TR]
[TR]
[TD]Jl. Tg. Batu No. 107, Pekanbaru,Pekanbaru,PEKAN BARU KOTA,PEKAN BARU,R I A U[/TD]
[TD]Jl. Tg. Batu No. 107, Pekanbaru[/TD]
[/TR]
[TR]
[TD]Jalan Budi Luhur RT.01/10, Kulim,Tenayan Raya,,,[/TD]
[TD]Jalan Budi Luhur RT.01/10, Kulim[/TD]
[/TR]
</tbody>[/TABLE]

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