[belajar-excel] substitute dengan wildcard

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] substitute dengan wildcard

fahmi syaifullah
Assalamu'alaikum wr.wb 
Mastah BeExceller mau tanya. 
intinya mengganti kata setelah tanda "(" jika contoh superman (nanda), maka dari tanda "("sampai kebelakang dihilangkan.saya gunakan substitute dengan pertolongan tanda "*" tapi ternyata tidak bisa.apakah ada cara lain selain substitue digabungkan dengan tanda * (wildcard).  mohon pencerahannya master.
terima kasih.wassalamu'alaikum wr.wb
Reply | Threaded
Open this post in threaded view
|

Bls: [belajar-excel] substitute dengan wildcard

od212
coba di padukan dengan mid, find br,

odong nando


      Dari: "Fahmi Syaifullah [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: BeExcel <[hidden email]>
 Dikirim: Jumat, 23 November 2018 14:28
 Judul: [belajar-excel] substitute dengan wildcard
   
    Assalamu'alaikum wr.wb 
Mastah BeExceller mau tanya. 
intinya mengganti kata setelah tanda "(" jika contoh superman (nanda), maka dari tanda "("sampai kebelakang dihilangkan.saya gunakan substitute dengan pertolongan tanda "*" tapi ternyata tidak bisa.apakah ada cara lain selain substitue digabungkan dengan tanda * (wildcard).  mohon pencerahannya master.
terima kasih.wassalamu'alaikum wr.wb  #yiv1522129639 #yiv1522129639 -- #yiv1522129639ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1522129639 #yiv1522129639ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1522129639 #yiv1522129639ygrp-mkp #yiv1522129639hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1522129639 #yiv1522129639ygrp-mkp #yiv1522129639ads {margin-bottom:10px;}#yiv1522129639 #yiv1522129639ygrp-mkp .yiv1522129639ad {padding:0 0;}#yiv1522129639 #yiv1522129639ygrp-mkp .yiv1522129639ad p {margin:0;}#yiv1522129639 #yiv1522129639ygrp-mkp .yiv1522129639ad a {color:#0000ff;text-decoration:none;}#yiv1522129639 #yiv1522129639ygrp-sponsor #yiv1522129639ygrp-lc {font-family:Arial;}#yiv1522129639 #yiv1522129639ygrp-sponsor #yiv1522129639ygrp-lc #yiv1522129639hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1522129639 #yiv1522129639ygrp-sponsor #yiv1522129639ygrp-lc .yiv1522129639ad {margin-bottom:10px;padding:0 0;}#yiv1522129639 #yiv1522129639actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1522129639 #yiv1522129639activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1522129639 #yiv1522129639activity span {font-weight:700;}#yiv1522129639 #yiv1522129639activity span:first-child {text-transform:uppercase;}#yiv1522129639 #yiv1522129639activity span a {color:#5085b6;text-decoration:none;}#yiv1522129639 #yiv1522129639activity span span {color:#ff7900;}#yiv1522129639 #yiv1522129639activity span .yiv1522129639underline {text-decoration:underline;}#yiv1522129639 .yiv1522129639attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1522129639 .yiv1522129639attach div a {text-decoration:none;}#yiv1522129639 .yiv1522129639attach img {border:none;padding-right:5px;}#yiv1522129639 .yiv1522129639attach label {display:block;margin-bottom:5px;}#yiv1522129639 .yiv1522129639attach label a {text-decoration:none;}#yiv1522129639 blockquote {margin:0 0 0 4px;}#yiv1522129639 .yiv1522129639bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1522129639 .yiv1522129639bold a {text-decoration:none;}#yiv1522129639 dd.yiv1522129639last p a {font-family:Verdana;font-weight:700;}#yiv1522129639 dd.yiv1522129639last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1522129639 dd.yiv1522129639last p span.yiv1522129639yshortcuts {margin-right:0;}#yiv1522129639 div.yiv1522129639attach-table div div a {text-decoration:none;}#yiv1522129639 div.yiv1522129639attach-table {width:400px;}#yiv1522129639 div..yiv1522129639file-title a, #yiv1522129639 div.yiv1522129639file-title a:active, #yiv1522129639 div.yiv1522129639file-title a:hover, #yiv1522129639 div.yiv1522129639file-title a:visited {text-decoration:none;}#yiv1522129639 div.yiv1522129639photo-title a, #yiv1522129639 div.yiv1522129639photo-title a:active, #yiv1522129639 div.yiv1522129639photo-title a:hover, #yiv1522129639 div.yiv1522129639photo-title a:visited {text-decoration:none;}#yiv1522129639 div#yiv1522129639ygrp-mlmsg #yiv1522129639ygrp-msg p a span.yiv1522129639yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1522129639 .yiv1522129639green {color:#628c2a;}#yiv1522129639 .yiv1522129639MsoNormal {margin:0 0 0 0;}#yiv1522129639 o {font-size:0;}#yiv1522129639 #yiv1522129639photos div {float:left;width:72px;}#yiv1522129639 #yiv1522129639photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1522129639 #yiv1522129639photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1522129639 #yiv1522129639reco-category {font-size:77%;}#yiv1522129639 #yiv1522129639reco-desc {font-size:77%;}#yiv1522129639 .yiv1522129639replbq {margin:4px;}#yiv1522129639 #yiv1522129639ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1522129639 #yiv1522129639ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1522129639 #yiv1522129639ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1522129639 #yiv1522129639ygrp-mlmsg select, #yiv1522129639 input, #yiv1522129639 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1522129639 #yiv1522129639ygrp-mlmsg pre, #yiv1522129639 code {font:115% monospace;}#yiv1522129639 #yiv1522129639ygrp-mlmsg * {line-height:1.22em;}#yiv1522129639 #yiv1522129639ygrp-mlmsg #yiv1522129639logo {padding-bottom:10px;}#yiv1522129639 #yiv1522129639ygrp-msg p a {font-family:Verdana;}#yiv1522129639 #yiv1522129639ygrp-msg p#yiv1522129639attach-count span {color:#1E66AE;font-weight:700;}#yiv1522129639 #yiv1522129639ygrp-reco #yiv1522129639reco-head {color:#ff7900;font-weight:700;}#yiv1522129639 #yiv1522129639ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1522129639 #yiv1522129639ygrp-sponsor #yiv1522129639ov li a {font-size:130%;text-decoration:none;}#yiv1522129639 #yiv1522129639ygrp-sponsor #yiv1522129639ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1522129639 #yiv1522129639ygrp-sponsor #yiv1522129639ov ul {margin:0;padding:0 0 0 8px;}#yiv1522129639 #yiv1522129639ygrp-text {font-family:Georgia;}#yiv1522129639 #yiv1522129639ygrp-text p {margin:0 0 1em 0;}#yiv1522129639 #yiv1522129639ygrp-text tt {font-size:120%;}#yiv1522129639 #yiv1522129639ygrp-vital ul li:last-child {border-right:none !important;}#yiv1522129639

   
Reply | Threaded
Open this post in threaded view
|

Re: Bls: [belajar-excel] substitute dengan wildcard

fahmi syaifullah
Bang odong masalahnya Ada data yang tidak pakai tanda kurung sperti itu.Yang pakai hanya sbagian.

Sent from Yahoo Mail on Android
 
  On Fri, Nov 23, 2018 at 3:06 PM, odong nando [hidden email] [belajar-excel]<[hidden email]> wrote:      

coba di padukan dengan mid, find br,

odong nando


      Dari: "Fahmi Syaifullah [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: BeExcel <[hidden email]>
 Dikirim: Jumat, 23 November 2018 14:28
 Judul: [belajar-excel] substitute dengan wildcard
 
    Assalamu'alaikum wr.wb 
Mastah BeExceller mau tanya. 
intinya mengganti kata setelah tanda "(" jika contoh superman (nanda), maka dari tanda "("sampai kebelakang dihilangkan.saya gunakan substitute dengan pertolongan tanda "*" tapi ternyata tidak bisa.apakah ada cara lain selain substitue digabungkan dengan tanda * (wildcard).  mohon pencerahannya master.
terima kasih.wassalamu'alaikum wr.wb  

     #yiv3743764406 #yiv3743764406 -- #yiv3743764406ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3743764406 #yiv3743764406ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3743764406 #yiv3743764406ygrp-mkp #yiv3743764406hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3743764406 #yiv3743764406ygrp-mkp #yiv3743764406ads {margin-bottom:10px;}#yiv3743764406 #yiv3743764406ygrp-mkp ..yiv3743764406ad {padding:0 0;}#yiv3743764406 #yiv3743764406ygrp-mkp .yiv3743764406ad p {margin:0;}#yiv3743764406 #yiv3743764406ygrp-mkp .yiv3743764406ad a {color:#0000ff;text-decoration:none;}#yiv3743764406 #yiv3743764406ygrp-sponsor #yiv3743764406ygrp-lc {font-family:Arial;}#yiv3743764406 #yiv3743764406ygrp-sponsor #yiv3743764406ygrp-lc #yiv3743764406hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3743764406 #yiv3743764406ygrp-sponsor #yiv3743764406ygrp-lc .yiv3743764406ad {margin-bottom:10px;padding:0 0;}#yiv3743764406 #yiv3743764406actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3743764406 #yiv3743764406activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3743764406 #yiv3743764406activity span {font-weight:700;}#yiv3743764406 #yiv3743764406activity span:first-child {text-transform:uppercase;}#yiv3743764406 #yiv3743764406activity span a {color:#5085b6;text-decoration:none;}#yiv3743764406 #yiv3743764406activity span span {color:#ff7900;}#yiv3743764406 #yiv3743764406activity span .yiv3743764406underline {text-decoration:underline;}#yiv3743764406 .yiv3743764406attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3743764406 .yiv3743764406attach div a {text-decoration:none;}#yiv3743764406 .yiv3743764406attach img {border:none;padding-right:5px;}#yiv3743764406 .yiv3743764406attach label {display:block;margin-bottom:5px;}#yiv3743764406 .yiv3743764406attach label a {text-decoration:none;}#yiv3743764406 blockquote {margin:0 0 0 4px;}#yiv3743764406 .yiv3743764406bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3743764406 .yiv3743764406bold a {text-decoration:none;}#yiv3743764406 dd.yiv3743764406last p a {font-family:Verdana;font-weight:700;}#yiv3743764406 dd.yiv3743764406last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3743764406 dd.yiv3743764406last p span.yiv3743764406yshortcuts {margin-right:0;}#yiv3743764406 div.yiv3743764406attach-table div div a {text-decoration:none;}#yiv3743764406 div.yiv3743764406attach-table {width:400px;}#yiv3743764406 div.yiv3743764406file-title a, #yiv3743764406 div.yiv3743764406file-title a:active, #yiv3743764406 div.yiv3743764406file-title a:hover, #yiv3743764406 div.yiv3743764406file-title a:visited {text-decoration:none;}#yiv3743764406 div.yiv3743764406photo-title a, #yiv3743764406 div.yiv3743764406photo-title a:active, #yiv3743764406 div.yiv3743764406photo-title a:hover, #yiv3743764406 div.yiv3743764406photo-title a:visited {text-decoration:none;}#yiv3743764406 div#yiv3743764406ygrp-mlmsg #yiv3743764406ygrp-msg p a span.yiv3743764406yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3743764406 .yiv3743764406green {color:#628c2a;}#yiv3743764406 .yiv3743764406MsoNormal {margin:0 0 0 0;}#yiv3743764406 o {font-size:0;}#yiv3743764406 #yiv3743764406photos div {float:left;width:72px;}#yiv3743764406 #yiv3743764406photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3743764406 #yiv3743764406photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3743764406 #yiv3743764406reco-category {font-size:77%;}#yiv3743764406 #yiv3743764406reco-desc {font-size:77%;}#yiv3743764406 .yiv3743764406replbq {margin:4px;}#yiv3743764406 #yiv3743764406ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3743764406 #yiv3743764406ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3743764406 #yiv3743764406ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3743764406 #yiv3743764406ygrp-mlmsg select, #yiv3743764406 input, #yiv3743764406 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3743764406 #yiv3743764406ygrp-mlmsg pre, #yiv3743764406 code {font:115% monospace;}#yiv3743764406 #yiv3743764406ygrp-mlmsg * {line-height:1.22em;}#yiv3743764406 #yiv3743764406ygrp-mlmsg #yiv3743764406logo {padding-bottom:10px;}#yiv3743764406 #yiv3743764406ygrp-msg p a {font-family:Verdana;}#yiv3743764406 #yiv3743764406ygrp-msg p#yiv3743764406attach-count span {color:#1E66AE;font-weight:700;}#yiv3743764406 #yiv3743764406ygrp-reco #yiv3743764406reco-head {color:#ff7900;font-weight:700;}#yiv3743764406 #yiv3743764406ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3743764406 #yiv3743764406ygrp-sponsor #yiv3743764406ov li a {font-size:130%;text-decoration:none;}#yiv3743764406 #yiv3743764406ygrp-sponsor #yiv3743764406ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3743764406 #yiv3743764406ygrp-sponsor #yiv3743764406ov ul {margin:0;padding:0 0 0 8px;}#yiv3743764406 #yiv3743764406ygrp-text {font-family:Georgia;}#yiv3743764406 #yiv3743764406ygrp-text p {margin:0 0 1em 0;}#yiv3743764406 #yiv3743764406ygrp-text tt {font-size:120%;}#yiv3743764406 #yiv3743764406ygrp-vital ul li:last-child {border-right:none !important;}#yiv3743764406  
Reply | Threaded
Open this post in threaded view
|

Bls: Bls: [belajar-excel] substitute dengan wildcard

od212
bisa di kelompokkan dulu mana2 yang mau dihapus, setelahnya baru mau di hapus sesuai dengan kelompok data yang mau di hapus atau di ganti dgn yang lain silakan... br,

odong nando


      Dari: "Fahmi Syaifullah [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Jumat, 23 November 2018 15:17
 Judul: Re: Bls: [belajar-excel] substitute dengan wildcard
   
    Bang odong masalahnya Ada data yang tidak pakai tanda kurung sperti itu.Yang pakai hanya sbagian.

Sent from Yahoo Mail on Android
 
  On Fri, Nov 23, 2018 at 3:06 PM, odong nando [hidden email] [belajar-excel]<[hidden email]> wrote:       coba di padukan dengan mid, find br,

odong nando


      Dari: "Fahmi Syaifullah [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: BeExcel <[hidden email]>
 Dikirim: Jumat, 23 November 2018 14:28
 Judul: [belajar-excel] substitute dengan wildcard
 
    Assalamu'alaikum wr.wb 
Mastah BeExceller mau tanya. 
intinya mengganti kata setelah tanda "(" jika contoh superman (nanda), maka dari tanda "("sampai kebelakang dihilangkan.saya gunakan substitute dengan pertolongan tanda "*" tapi ternyata tidak bisa.apakah ada cara lain selain substitue digabungkan dengan tanda * (wildcard).  mohon pencerahannya master.
terima kasih.wassalamu'alaikum wr.wb  

       
  #yiv6443684323 #yiv6443684323 -- #yiv6443684323ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6443684323 #yiv6443684323ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6443684323 #yiv6443684323ygrp-mkp #yiv6443684323hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6443684323 #yiv6443684323ygrp-mkp #yiv6443684323ads {margin-bottom:10px;}#yiv6443684323 #yiv6443684323ygrp-mkp .yiv6443684323ad {padding:0 0;}#yiv6443684323 #yiv6443684323ygrp-mkp .yiv6443684323ad p {margin:0;}#yiv6443684323 #yiv6443684323ygrp-mkp .yiv6443684323ad a {color:#0000ff;text-decoration:none;}#yiv6443684323 #yiv6443684323ygrp-sponsor #yiv6443684323ygrp-lc {font-family:Arial;}#yiv6443684323 #yiv6443684323ygrp-sponsor #yiv6443684323ygrp-lc #yiv6443684323hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6443684323 #yiv6443684323ygrp-sponsor #yiv6443684323ygrp-lc .yiv6443684323ad {margin-bottom:10px;padding:0 0;}#yiv6443684323 #yiv6443684323actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6443684323 #yiv6443684323activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6443684323 #yiv6443684323activity span {font-weight:700;}#yiv6443684323 #yiv6443684323activity span:first-child {text-transform:uppercase;}#yiv6443684323 #yiv6443684323activity span a {color:#5085b6;text-decoration:none;}#yiv6443684323 #yiv6443684323activity span span {color:#ff7900;}#yiv6443684323 #yiv6443684323activity span .yiv6443684323underline {text-decoration:underline;}#yiv6443684323 .yiv6443684323attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6443684323 .yiv6443684323attach div a {text-decoration:none;}#yiv6443684323 .yiv6443684323attach img {border:none;padding-right:5px;}#yiv6443684323 .yiv6443684323attach label {display:block;margin-bottom:5px;}#yiv6443684323 .yiv6443684323attach label a {text-decoration:none;}#yiv6443684323 blockquote {margin:0 0 0 4px;}#yiv6443684323 .yiv6443684323bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6443684323 .yiv6443684323bold a {text-decoration:none;}#yiv6443684323 dd.yiv6443684323last p a {font-family:Verdana;font-weight:700;}#yiv6443684323 dd.yiv6443684323last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6443684323 dd.yiv6443684323last p span.yiv6443684323yshortcuts {margin-right:0;}#yiv6443684323 div.yiv6443684323attach-table div div a {text-decoration:none;}#yiv6443684323 div.yiv6443684323attach-table {width:400px;}#yiv6443684323 div.yiv6443684323file-title a, #yiv6443684323 div.yiv6443684323file-title a:active, #yiv6443684323 div.yiv6443684323file-title a:hover, #yiv6443684323 div.yiv6443684323file-title a:visited {text-decoration:none;}#yiv6443684323 div.yiv6443684323photo-title a, #yiv6443684323 div.yiv6443684323photo-title a:active, #yiv6443684323 div.yiv6443684323photo-title a:hover, #yiv6443684323 div.yiv6443684323photo-title a:visited {text-decoration:none;}#yiv6443684323 div#yiv6443684323ygrp-mlmsg #yiv6443684323ygrp-msg p a span.yiv6443684323yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6443684323 .yiv6443684323green {color:#628c2a;}#yiv6443684323 .yiv6443684323MsoNormal {margin:0 0 0 0;}#yiv6443684323 o {font-size:0;}#yiv6443684323 #yiv6443684323photos div {float:left;width:72px;}#yiv6443684323 #yiv6443684323photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6443684323 #yiv6443684323photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6443684323 #yiv6443684323reco-category {font-size:77%;}#yiv6443684323 #yiv6443684323reco-desc {font-size:77%;}#yiv6443684323 .yiv6443684323replbq {margin:4px;}#yiv6443684323 #yiv6443684323ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6443684323 #yiv6443684323ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6443684323 #yiv6443684323ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6443684323 #yiv6443684323ygrp-mlmsg select, #yiv6443684323 input, #yiv6443684323 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6443684323 #yiv6443684323ygrp-mlmsg pre, #yiv6443684323 code {font:115% monospace;}#yiv6443684323 #yiv6443684323ygrp-mlmsg * {line-height:1.22em;}#yiv6443684323 #yiv6443684323ygrp-mlmsg #yiv6443684323logo {padding-bottom:10px;}#yiv6443684323 #yiv6443684323ygrp-msg p a {font-family:Verdana;}#yiv6443684323 #yiv6443684323ygrp-msg p#yiv6443684323attach-count span {color:#1E66AE;font-weight:700;}#yiv6443684323 #yiv6443684323ygrp-reco #yiv6443684323reco-head {color:#ff7900;font-weight:700;}#yiv6443684323 #yiv6443684323ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6443684323 #yiv6443684323ygrp-sponsor #yiv6443684323ov li a {font-size:130%;text-decoration:none;}#yiv6443684323 #yiv6443684323ygrp-sponsor #yiv6443684323ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6443684323 #yiv6443684323ygrp-sponsor #yiv6443684323ov ul {margin:0;padding:0 0 0 8px;}#yiv6443684323 #yiv6443684323ygrp-text {font-family:Georgia;}#yiv6443684323 #yiv6443684323ygrp-text p {margin:0 0 1em 0;}#yiv6443684323 #yiv6443684323ygrp-text tt {font-size:120%;}#yiv6443684323 #yiv6443684323ygrp-vital ul li:last-child {border-right:none !important;}#yiv6443684323

   
Reply | Threaded
Open this post in threaded view
|

Re: Bls: Bls: [belajar-excel] substitute dengan wildcard

fahmi syaifullah
 oke bang odong terima kasih banyak..
fahmi
    Pada Jumat, 23 November 2018 15.34.00 WIB, odong nando odongnando@yahoo..com [belajar-excel] <[hidden email]> menulis:  
 
    

bisa di kelompokkan dulu mana2 yang mau dihapus, setelahnya baru mau di hapus sesuai dengan kelompok data yang mau di hapus atau di ganti dgn yang lain silakan... br,

odong nando


      Dari: "Fahmi Syaifullah [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Jumat, 23 November 2018 15:17
 Judul: Re: Bls: [belajar-excel] substitute dengan wildcard
 
    Bang odong masalahnya Ada data yang tidak pakai tanda kurung sperti itu.Yang pakai hanya sbagian.

Sent from Yahoo Mail on Android
 
  On Fri, Nov 23, 2018 at 3:06 PM, odong nando [hidden email] [belajar-excel]<[hidden email]> wrote:       coba di padukan dengan mid, find br,

odong nando


      Dari: "Fahmi Syaifullah [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: BeExcel <[hidden email]>
 Dikirim: Jumat, 23 November 2018 14:28
 Judul: [belajar-excel] substitute dengan wildcard
 
    Assalamu'alaikum wr.wb 
Mastah BeExceller mau tanya. 
intinya mengganti kata setelah tanda "(" jika contoh superman (nanda), maka dari tanda "("sampai kebelakang dihilangkan.saya gunakan substitute dengan pertolongan tanda "*" tapi ternyata tidak bisa.apakah ada cara lain selain substitue digabungkan dengan tanda * (wildcard).  mohon pencerahannya master.
terima kasih.wassalamu'alaikum wr.wb  

       
 

     #yiv0773970430 #yiv0773970430 -- #yiv0773970430ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0773970430 #yiv0773970430ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0773970430 #yiv0773970430ygrp-mkp #yiv0773970430hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0773970430 #yiv0773970430ygrp-mkp #yiv0773970430ads {margin-bottom:10px;}#yiv0773970430 #yiv0773970430ygrp-mkp ..yiv0773970430ad {padding:0 0;}#yiv0773970430 #yiv0773970430ygrp-mkp .yiv0773970430ad p {margin:0;}#yiv0773970430 #yiv0773970430ygrp-mkp .yiv0773970430ad a {color:#0000ff;text-decoration:none;}#yiv0773970430 #yiv0773970430ygrp-sponsor #yiv0773970430ygrp-lc {font-family:Arial;}#yiv0773970430 #yiv0773970430ygrp-sponsor #yiv0773970430ygrp-lc #yiv0773970430hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0773970430 #yiv0773970430ygrp-sponsor #yiv0773970430ygrp-lc .yiv0773970430ad {margin-bottom:10px;padding:0 0;}#yiv0773970430 #yiv0773970430actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0773970430 #yiv0773970430activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0773970430 #yiv0773970430activity span {font-weight:700;}#yiv0773970430 #yiv0773970430activity span:first-child {text-transform:uppercase;}#yiv0773970430 #yiv0773970430activity span a {color:#5085b6;text-decoration:none;}#yiv0773970430 #yiv0773970430activity span span {color:#ff7900;}#yiv0773970430 #yiv0773970430activity span .yiv0773970430underline {text-decoration:underline;}#yiv0773970430 .yiv0773970430attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0773970430 .yiv0773970430attach div a {text-decoration:none;}#yiv0773970430 .yiv0773970430attach img {border:none;padding-right:5px;}#yiv0773970430 .yiv0773970430attach label {display:block;margin-bottom:5px;}#yiv0773970430 .yiv0773970430attach label a {text-decoration:none;}#yiv0773970430 blockquote {margin:0 0 0 4px;}#yiv0773970430 .yiv0773970430bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0773970430 .yiv0773970430bold a {text-decoration:none;}#yiv0773970430 dd.yiv0773970430last p a {font-family:Verdana;font-weight:700;}#yiv0773970430 dd.yiv0773970430last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0773970430 dd.yiv0773970430last p span.yiv0773970430yshortcuts {margin-right:0;}#yiv0773970430 div.yiv0773970430attach-table div div a {text-decoration:none;}#yiv0773970430 div.yiv0773970430attach-table {width:400px;}#yiv0773970430 div.yiv0773970430file-title a, #yiv0773970430 div.yiv0773970430file-title a:active, #yiv0773970430 div.yiv0773970430file-title a:hover, #yiv0773970430 div.yiv0773970430file-title a:visited {text-decoration:none;}#yiv0773970430 div.yiv0773970430photo-title a, #yiv0773970430 div.yiv0773970430photo-title a:active, #yiv0773970430 div.yiv0773970430photo-title a:hover, #yiv0773970430 div.yiv0773970430photo-title a:visited {text-decoration:none;}#yiv0773970430 div#yiv0773970430ygrp-mlmsg #yiv0773970430ygrp-msg p a span.yiv0773970430yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0773970430 .yiv0773970430green {color:#628c2a;}#yiv0773970430 .yiv0773970430MsoNormal {margin:0 0 0 0;}#yiv0773970430 o {font-size:0;}#yiv0773970430 #yiv0773970430photos div {float:left;width:72px;}#yiv0773970430 #yiv0773970430photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0773970430 #yiv0773970430photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0773970430 #yiv0773970430reco-category {font-size:77%;}#yiv0773970430 #yiv0773970430reco-desc {font-size:77%;}#yiv0773970430 .yiv0773970430replbq {margin:4px;}#yiv0773970430 #yiv0773970430ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0773970430 #yiv0773970430ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0773970430 #yiv0773970430ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0773970430 #yiv0773970430ygrp-mlmsg select, #yiv0773970430 input, #yiv0773970430 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0773970430 #yiv0773970430ygrp-mlmsg pre, #yiv0773970430 code {font:115% monospace;}#yiv0773970430 #yiv0773970430ygrp-mlmsg * {line-height:1.22em;}#yiv0773970430 #yiv0773970430ygrp-mlmsg #yiv0773970430logo {padding-bottom:10px;}#yiv0773970430 #yiv0773970430ygrp-msg p a {font-family:Verdana;}#yiv0773970430 #yiv0773970430ygrp-msg p#yiv0773970430attach-count span {color:#1E66AE;font-weight:700;}#yiv0773970430 #yiv0773970430ygrp-reco #yiv0773970430reco-head {color:#ff7900;font-weight:700;}#yiv0773970430 #yiv0773970430ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0773970430 #yiv0773970430ygrp-sponsor #yiv0773970430ov li a {font-size:130%;text-decoration:none;}#yiv0773970430 #yiv0773970430ygrp-sponsor #yiv0773970430ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0773970430 #yiv0773970430ygrp-sponsor #yiv0773970430ov ul {margin:0;padding:0 0 0 8px;}#yiv0773970430 #yiv0773970430ygrp-text {font-family:Georgia;}#yiv0773970430 #yiv0773970430ygrp-text p {margin:0 0 1em 0;}#yiv0773970430 #yiv0773970430ygrp-text tt {font-size:120%;}#yiv0773970430 #yiv0773970430ygrp-vital ul li:last-child {border-right:none !important;}#yiv0773970430