Terima kasih pak Zainul Akan saya coba juga untuk formula nya
On Dec 22, 2017 4:09 PM, "Zainul Ulum zainul_u...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote: > > > Pak Rachmat, > > coba rumus ini: > =IF(ISERR(FIND("-",[@ORI])),[@ORI],-1*(SUBSTITUTE([@ORI],"-",REPT(" > ",99)))) > > Thanks, > -zainul > > #dikirim_pakai_mail.yahoo.com_tanpa_pulsa# > > -------------------------------------------- > On Fri, 22/12/17, Rachmat Hidayat my.androi...@gmail.com [belajar-excel] < > belajar-ex...@yahoogroups...com> wrote: > > Subject: [belajar-excel] #ask#formula 22122017 > To: belajar-excel@yahoogroups.com > Date: Friday, 22 December, 2017, 2:52 PM > > > > > > > > > > > > > Dear Master Excel, Semoga dalam keadaan sehat > wal’afiat, mohon bantuan nya bagaimana cara menghilangkan > tanda (-) yang berada di belakang angka contoh 009- > dan tanda (-) nya dipindahkan kedepan angka tersebut > Untuk detail mohon dilihat file excel nya Sent from Mail > for Windows 10 > > > > > > > > > > > #yiv4479021898 #yiv4479021898 -- > #yiv4479021898ygrp-mkp { > border:1px solid #d8d8d8;font-family:Arial;margin:10px > 0;padding:0 10px;} > > #yiv4479021898 #yiv4479021898ygrp-mkp hr { > border:1px solid #d8d8d8;} > > #yiv4479021898 #yiv4479021898ygrp-mkp #yiv4479021898hd { > color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px > 0;} > > #yiv4479021898 #yiv4479021898ygrp-mkp #yiv4479021898ads { > margin-bottom:10px;} > > #yiv4479021898 #yiv4479021898ygrp-mkp .yiv4479021898ad { > padding:0 0;} > > #yiv4479021898 #yiv4479021898ygrp-mkp .yiv4479021898ad p { > margin:0;} > > #yiv4479021898 #yiv4479021898ygrp-mkp .yiv4479021898ad a { > color:#0000ff;text-decoration:none;} > #yiv4479021898 #yiv4479021898ygrp-sponsor > #yiv4479021898ygrp-lc { > font-family:Arial;} > > #yiv4479021898 #yiv4479021898ygrp-sponsor > #yiv4479021898ygrp-lc #yiv4479021898hd { > margin:10px > 0px;font-weight:700;font-size:78%;line-height:122%;} > > #yiv4479021898 #yiv4479021898ygrp-sponsor > #yiv4479021898ygrp-lc .yiv4479021898ad { > margin-bottom:10px;padding:0 0;} > > #yiv4479021898 #yiv4479021898actions { > font-family:Verdana;font-size:11px;padding:10px 0;} > > #yiv4479021898 #yiv4479021898activity { > background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px; > padding:10px;} > > #yiv4479021898 #yiv4479021898activity span { > font-weight:700;} > > #yiv4479021898 #yiv4479021898activity span:first-child { > text-transform:uppercase;} > > #yiv4479021898 #yiv4479021898activity span a { > color:#5085b6;text-decoration:none;} > > #yiv4479021898 #yiv4479021898activity span span { > color:#ff7900;} > > #yiv4479021898 #yiv4479021898activity span > .yiv4479021898underline { > text-decoration:underline;} > > #yiv4479021898 .yiv4479021898attach { > clear:both;display:table;font-family:Arial;font-size:12px;padding:10px > 0;width:400px;} > > #yiv4479021898 .yiv4479021898attach div a { > text-decoration:none;} > > #yiv4479021898 .yiv4479021898attach img { > border:none;padding-right:5px;} > > #yiv4479021898 .yiv4479021898attach label { > display:block;margin-bottom:5px;} > > #yiv4479021898 .yiv4479021898attach label a { > text-decoration:none;} > > #yiv4479021898 blockquote { > margin:0 0 0 4px;} > > #yiv4479021898 .yiv4479021898bold { > font-family:Arial;font-size:13px;font-weight:700;} > > #yiv4479021898 .yiv4479021898bold a { > text-decoration:none;} > > #yiv4479021898 dd.yiv4479021898last p a { > font-family:Verdana;font-weight:700;} > > #yiv4479021898 dd.yiv4479021898last p span { > margin-right:10px;font-family:Verdana;font-weight:700;} > > #yiv4479021898 dd.yiv4479021898last p > span.yiv4479021898yshortcuts { > margin-right:0;} > > #yiv4479021898 div.yiv4479021898attach-table div div a { > text-decoration:none;} > > #yiv4479021898 div.yiv4479021898attach-table { > width:400px;} > > #yiv4479021898 div.yiv4479021898file-title a, #yiv4479021898 > div.yiv4479021898file-title a:active, #yiv4479021898 > div.yiv4479021898file-title a:hover, #yiv4479021898 > div.yiv4479021898file-title a:visited { > text-decoration:none;} > > #yiv4479021898 div.yiv4479021898photo-title a, > #yiv4479021898 div.yiv4479021898photo-title a:active, > #yiv4479021898 div.yiv4479021898photo-title a:hover, > #yiv4479021898 div.yiv4479021898photo-title a:visited { > text-decoration:none;} > > #yiv4479021898 div#yiv4479021898ygrp-mlmsg > #yiv4479021898ygrp-msg p a span.yiv4479021898yshortcuts { > font-family:Verdana;font-size:10px;font-weight:normal;} > > #yiv4479021898 .yiv4479021898green { > color:#628c2a;} > > #yiv4479021898 .yiv4479021898MsoNormal { > margin:0 0 0 0;} > > #yiv4479021898 o { > font-size:0;} > > #yiv4479021898 #yiv4479021898photos div { > float:left;width:72px;} > > #yiv4479021898 #yiv4479021898photos div div { > border:1px solid > #666666;min-height:62px;overflow:hidden;width:62px;} > > #yiv4479021898 #yiv4479021898photos div label { > color:#666666;font-size:10px;overflow:hidden;text-align: > center;white-space:nowrap;width:64px;} > > #yiv4479021898 #yiv4479021898reco-category { > font-size:77%;} > > #yiv4479021898 #yiv4479021898reco-desc { > font-size:77%;} > > #yiv4479021898 .yiv4479021898replbq { > margin:4px;} > > #yiv4479021898 #yiv4479021898ygrp-actbar div a:first-child { > margin-right:2px;padding-right:5px;} > > #yiv4479021898 #yiv4479021898ygrp-mlmsg { > font-size:13px;font-family:Arial, helvetica, clean, > sans-serif;} > > #yiv4479021898 #yiv4479021898ygrp-mlmsg table { > font-size:inherit;font:100%;} > > #yiv4479021898 #yiv4479021898ygrp-mlmsg select, > #yiv4479021898 input, #yiv4479021898 textarea { > font:99% Arial, Helvetica, clean, sans-serif;} > > #yiv4479021898 #yiv4479021898ygrp-mlmsg pre, #yiv4479021898 > code { > font:115% monospace;} > > #yiv4479021898 #yiv4479021898ygrp-mlmsg * { > line-height:1.22em;} > > #yiv4479021898 #yiv4479021898ygrp-mlmsg #yiv4479021898logo { > padding-bottom:10px;} > > > #yiv4479021898 #yiv4479021898ygrp-msg p a { > font-family:Verdana;} > > #yiv4479021898 #yiv4479021898ygrp-msg > p#yiv4479021898attach-count span { > color:#1E66AE;font-weight:700;} > > #yiv4479021898 #yiv4479021898ygrp-reco > #yiv4479021898reco-head { > color:#ff7900;font-weight:700;} > > #yiv4479021898 #yiv4479021898ygrp-reco { > margin-bottom:20px;padding:0px;} > > #yiv4479021898 #yiv4479021898ygrp-sponsor #yiv4479021898ov > li a { > font-size:130%;text-decoration:none;} > > #yiv4479021898 #yiv4479021898ygrp-sponsor #yiv4479021898ov > li { > font-size:77%;list-style-type:square;padding:6px 0;} > > #yiv4479021898 #yiv4479021898ygrp-sponsor #yiv4479021898ov > ul { > margin:0;padding:0 0 0 8px;} > > #yiv4479021898 #yiv4479021898ygrp-text { > font-family:Georgia;} > > #yiv4479021898 #yiv4479021898ygrp-text p { > margin:0 0 1em 0;} > > #yiv4479021898 #yiv4479021898ygrp-text tt { > font-size:120%;} > > #yiv4479021898 #yiv4479021898ygrp-vital ul li:last-child { > border-right:none !important; > } > #yiv4479021898 > > >