muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
i have problem, how to extract text before word "Golongan"
like this
Excel 2007 32 bit
<tbody>
</tbody>
<tbody>
</tbody>
anyone would help me..
m.susanto
i have problem, how to extract text before word "Golongan"
like this
Excel 2007 32 bit
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR] | |
---|---|---|
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR] | DATA/TEXT | EXTRACT |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR] | Rumah Negara Golongan I Tipe C Permanen | Rumah Negara |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR] | Rumah Negara Golongan I Tipe B Permanen | Rumah Negara |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR] | Bangunan Gedung Kantor Permanen | Bangunan Gedung Kantor Permanen |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR] | Pagar Permanen | Pagar Permanen |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>
anyone would help me..
m.susanto
Last edited: