muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
i want to extract text from left after second mark "comma" :
the clue is red font comma mark..
<tbody>
</tbody>
any assistance much appreciated,,
m.susanto
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