yoo murni,
kyaknya bisa pake if ifan dah,
=IF ( ISNUMBER ( FIND ( "BUMN" ; _text yang akan di cari_) ) ; "BUMN"; "NON
BUMN")
bila regional kompi setempat adalah english maka ganti karakter titik koma " ;
" menjadi koma " , " artinya cari kata "BUMN" oleh fungsi FIND bila terdapat
maka ISNUMBER akan menghasilkan nilai numerik di karak keberapa BUMN ditemukan
, dan bila angka numerik selain nol " 0 " di temukan oleh fungsi IF atas
transformasi ISNUMBER maka fungsi IF akan memunculkan "BUMN", namun jika
ISNUMBER menghasilkan nilai nol " 0 " maka IF akan menghasilkan "NON BUMN".
br,
odong nando
Pada Rabu, 2 Desember 2015 14:55, "Murni Always
[email protected] [belajar-excel]" <[email protected]>
menulis:
Dear Para Master,
Mohon Pencerahaan dan bantuanya,
bagaimana cara mengambil kode BUMN (file terlampir),saya sudah coba menggunakan
mid,left,right tapi tetap saja karena posisi kode BUMN bervariasi.ada yang
ditengah kalimat, dibelakang, kadang juga didepan jadi saya harus kerja
beberapa kali untuk memisahkan kata BUMN.adakah cara lain untuk menyelesaikan
kesulitan saya ini para master ?
terima kasih sebelumnya atas bantuannya.
Salam
Murni
#yiv4324093157 #yiv4324093157 -- #yiv4324093157ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4324093157
#yiv4324093157ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4324093157
#yiv4324093157ygrp-mkp #yiv4324093157hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4324093157 #yiv4324093157ygrp-mkp #yiv4324093157ads
{margin-bottom:10px;}#yiv4324093157 #yiv4324093157ygrp-mkp .yiv4324093157ad
{padding:0 0;}#yiv4324093157 #yiv4324093157ygrp-mkp .yiv4324093157ad p
{margin:0;}#yiv4324093157 #yiv4324093157ygrp-mkp .yiv4324093157ad a
{color:#0000ff;text-decoration:none;}#yiv4324093157 #yiv4324093157ygrp-sponsor
#yiv4324093157ygrp-lc {font-family:Arial;}#yiv4324093157
#yiv4324093157ygrp-sponsor #yiv4324093157ygrp-lc #yiv4324093157hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4324093157
#yiv4324093157ygrp-sponsor #yiv4324093157ygrp-lc .yiv4324093157ad
{margin-bottom:10px;padding:0 0;}#yiv4324093157 #yiv4324093157actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4324093157
#yiv4324093157activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4324093157
#yiv4324093157activity span {font-weight:700;}#yiv4324093157
#yiv4324093157activity span:first-child
{text-transform:uppercase;}#yiv4324093157 #yiv4324093157activity span a
{color:#5085b6;text-decoration:none;}#yiv4324093157 #yiv4324093157activity span
span {color:#ff7900;}#yiv4324093157 #yiv4324093157activity span
.yiv4324093157underline {text-decoration:underline;}#yiv4324093157
.yiv4324093157attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4324093157 .yiv4324093157attach div a
{text-decoration:none;}#yiv4324093157 .yiv4324093157attach img
{border:none;padding-right:5px;}#yiv4324093157 .yiv4324093157attach label
{display:block;margin-bottom:5px;}#yiv4324093157 .yiv4324093157attach label a
{text-decoration:none;}#yiv4324093157 blockquote {margin:0 0 0
4px;}#yiv4324093157 .yiv4324093157bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4324093157
.yiv4324093157bold a {text-decoration:none;}#yiv4324093157 dd.yiv4324093157last
p a {font-family:Verdana;font-weight:700;}#yiv4324093157 dd.yiv4324093157last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4324093157
dd.yiv4324093157last p span.yiv4324093157yshortcuts
{margin-right:0;}#yiv4324093157 div.yiv4324093157attach-table div div a
{text-decoration:none;}#yiv4324093157 div.yiv4324093157attach-table
{width:400px;}#yiv4324093157 div.yiv4324093157file-title a, #yiv4324093157
div.yiv4324093157file-title a:active, #yiv4324093157
div.yiv4324093157file-title a:hover, #yiv4324093157 div.yiv4324093157file-title
a:visited {text-decoration:none;}#yiv4324093157 div.yiv4324093157photo-title a,
#yiv4324093157 div.yiv4324093157photo-title a:active, #yiv4324093157
div.yiv4324093157photo-title a:hover, #yiv4324093157
div.yiv4324093157photo-title a:visited {text-decoration:none;}#yiv4324093157
div#yiv4324093157ygrp-mlmsg #yiv4324093157ygrp-msg p a
span.yiv4324093157yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4324093157
.yiv4324093157green {color:#628c2a;}#yiv4324093157 .yiv4324093157MsoNormal
{margin:0 0 0 0;}#yiv4324093157 o {font-size:0;}#yiv4324093157
#yiv4324093157photos div {float:left;width:72px;}#yiv4324093157
#yiv4324093157photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4324093157
#yiv4324093157photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4324093157
#yiv4324093157reco-category {font-size:77%;}#yiv4324093157
#yiv4324093157reco-desc {font-size:77%;}#yiv4324093157 .yiv4324093157replbq
{margin:4px;}#yiv4324093157 #yiv4324093157ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4324093157 #yiv4324093157ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4324093157
#yiv4324093157ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4324093157
#yiv4324093157ygrp-mlmsg select, #yiv4324093157 input, #yiv4324093157 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4324093157
#yiv4324093157ygrp-mlmsg pre, #yiv4324093157 code {font:115%
monospace;}#yiv4324093157 #yiv4324093157ygrp-mlmsg *
{line-height:1.22em;}#yiv4324093157 #yiv4324093157ygrp-mlmsg #yiv4324093157logo
{padding-bottom:10px;}#yiv4324093157 #yiv4324093157ygrp-msg p a
{font-family:Verdana;}#yiv4324093157 #yiv4324093157ygrp-msg
p#yiv4324093157attach-count span {color:#1E66AE;font-weight:700;}#yiv4324093157
#yiv4324093157ygrp-reco #yiv4324093157reco-head
{color:#ff7900;font-weight:700;}#yiv4324093157 #yiv4324093157ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4324093157 #yiv4324093157ygrp-sponsor
#yiv4324093157ov li a {font-size:130%;text-decoration:none;}#yiv4324093157
#yiv4324093157ygrp-sponsor #yiv4324093157ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4324093157
#yiv4324093157ygrp-sponsor #yiv4324093157ov ul {margin:0;padding:0 0 0
8px;}#yiv4324093157 #yiv4324093157ygrp-text
{font-family:Georgia;}#yiv4324093157 #yiv4324093157ygrp-text p {margin:0 0 1em
0;}#yiv4324093157 #yiv4324093157ygrp-text tt {font-size:120%;}#yiv4324093157
#yiv4324093157ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4324093157
