[belajar-excel] Digest Number 4652

Milis Belajar Microsoft Excel Group

5 Messages

Digest #4652

1a

substitute dengan wildcard by "Fahmi Syaifullah" fahmisyaifullah20

1b

Bls: [belajar-excel] substitute dengan wildcard by "odong nando"

1c

Re: Bls: [belajar-excel] substitute dengan wildcard by "Fahmi Syaifullah" fahmisyaifullah20

1d

Bls: Bls: [belajar-excel] substitute dengan wildcard by "odong nando"

1e

Re: Bls: Bls: [belajar-excel] substitute dengan wildcard by "Fahmi Syaifullah" fahmisyaifullah20

Messages

1a

substitute dengan wildcard

Thu Nov 22, 2018 11:28 pm (PST) . Posted by:

"Fahmi Syaifullah" fahmisyaifullah20

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 to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

1b

Bls: [belajar-excel] substitute dengan wildcard

Fri Nov 23, 2018 12:05 am (PST) . Posted by:

"odong nando"

coba di padukan dengan mid, find br,

odong nando

Dari: "Fahmi Syaifullah fahmisyaifullah20@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
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&#39;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 to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

1c

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

Fri Nov 23, 2018 12:16 am (PST) . Posted by:

"Fahmi Syaifullah" fahmisyaifullah20

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 odongnando@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

coba di padukan dengan mid, find br,

odong nando

Dari: "Fahmi Syaifullah fahmisyaifullah20@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
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&#39;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 to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

1d

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

Fri Nov 23, 2018 12:33 am (PST) . Posted by:

"odong nando"

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 fahmisyaifullah20@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
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 odongnando@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:   coba di padukan dengan mid, find br,

odong nando

Dari: "Fahmi Syaifullah fahmisyaifullah20@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
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&#39;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 to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

1e

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

Fri Nov 23, 2018 1:40 am (PST) . Posted by:

"Fahmi Syaifullah" fahmisyaifullah20

oke bang odong terima kasih banyak..
fahmi
Pada Jumat, 23 November 2018 15.34.00 WIB, odong nando odongnando@yahoo..com [belajar-excel] <belajar-excel@yahoogroups.com> 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 fahmisyaifullah20@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
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 odongnando@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:   coba di padukan dengan mid, find br,

odong nando

Dari: "Fahmi Syaifullah fahmisyaifullah20@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
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&#39;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

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use