Hai Odong Nando,Mengapa format cell gabung harus berformat value ? Salam,HK
From: "odong nando odongna...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> To: Belajar Excel <belajar-excel@yahoogroups.com> Sent: Wednesday, 19 November 2014, 13:28 Subject: [belajar-excel] Custom format cell dengan ref value cell lain [1 Attachment] | dear all,saya punya kendala untuk membuat, format cell column gabung berformat value cell dari gabungan column kode_barang dan nama_barang dengan menggunakan pipe sebagai pembatas, seperti contoh pada column gabung, terlampir contoh masalah.Saya dapat melakukannya secara manual, namun akan memakan waktu yang sangat lama apabila yang harus di ketik ribuan baris.bagaimanakah caranya agar dapat di permudah.mohon arahan dari rekan2 sekalianbr,odong nando | <!--#yiv8530230361 #yiv8530230361ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8530230361 #yiv8530230361ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8530230361 #yiv8530230361ygrp-mkp #yiv8530230361hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8530230361 #yiv8530230361ygrp-mkp #yiv8530230361ads {margin-bottom:10px;}#yiv8530230361 #yiv8530230361ygrp-mkp .yiv8530230361ad {padding:0 0;}#yiv8530230361 #yiv8530230361ygrp-mkp .yiv8530230361ad p {margin:0;}#yiv8530230361 #yiv8530230361ygrp-mkp .yiv8530230361ad a {color:#0000ff;text-decoration:none;}#yiv8530230361 #yiv8530230361ygrp-sponsor #yiv8530230361ygrp-lc {font-family:Arial;}#yiv8530230361 #yiv8530230361ygrp-sponsor #yiv8530230361ygrp-lc #yiv8530230361hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8530230361 #yiv8530230361ygrp-sponsor #yiv8530230361ygrp-lc .yiv8530230361ad {margin-bottom:10px;padding:0 0;}#yiv8530230361 #yiv8530230361actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8530230361 #yiv8530230361activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8530230361 #yiv8530230361activity span {font-weight:700;}#yiv8530230361 #yiv8530230361activity span:first-child {text-transform:uppercase;}#yiv8530230361 #yiv8530230361activity span a {color:#5085b6;text-decoration:none;}#yiv8530230361 #yiv8530230361activity span span {color:#ff7900;}#yiv8530230361 #yiv8530230361activity span .yiv8530230361underline {text-decoration:underline;}#yiv8530230361 .yiv8530230361attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8530230361 .yiv8530230361attach div a {text-decoration:none;}#yiv8530230361 .yiv8530230361attach img {border:none;padding-right:5px;}#yiv8530230361 .yiv8530230361attach label {display:block;margin-bottom:5px;}#yiv8530230361 .yiv8530230361attach label a {text-decoration:none;}#yiv8530230361 blockquote {margin:0 0 0 4px;}#yiv8530230361 .yiv8530230361bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8530230361 .yiv8530230361bold a {text-decoration:none;}#yiv8530230361 dd.yiv8530230361last p a {font-family:Verdana;font-weight:700;}#yiv8530230361 dd.yiv8530230361last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8530230361 dd.yiv8530230361last p span.yiv8530230361yshortcuts {margin-right:0;}#yiv8530230361 div.yiv8530230361attach-table div div a {text-decoration:none;}#yiv8530230361 div.yiv8530230361attach-table {width:400px;}#yiv8530230361 div.yiv8530230361file-title a, #yiv8530230361 div.yiv8530230361file-title a:active, #yiv8530230361 div.yiv8530230361file-title a:hover, #yiv8530230361 div.yiv8530230361file-title a:visited {text-decoration:none;}#yiv8530230361 div.yiv8530230361photo-title a, #yiv8530230361 div.yiv8530230361photo-title a:active, #yiv8530230361 div.yiv8530230361photo-title a:hover, #yiv8530230361 div.yiv8530230361photo-title a:visited {text-decoration:none;}#yiv8530230361 div#yiv8530230361ygrp-mlmsg #yiv8530230361ygrp-msg p a span.yiv8530230361yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8530230361 .yiv8530230361green {color:#628c2a;}#yiv8530230361 .yiv8530230361MsoNormal {margin:0 0 0 0;}#yiv8530230361 o {font-size:0;}#yiv8530230361 #yiv8530230361photos div {float:left;width:72px;}#yiv8530230361 #yiv8530230361photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8530230361 #yiv8530230361photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8530230361 #yiv8530230361reco-category {font-size:77%;}#yiv8530230361 #yiv8530230361reco-desc {font-size:77%;}#yiv8530230361 .yiv8530230361replbq {margin:4px;}#yiv8530230361 #yiv8530230361ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8530230361 #yiv8530230361ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8530230361 #yiv8530230361ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8530230361 #yiv8530230361ygrp-mlmsg select, #yiv8530230361 input, #yiv8530230361 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8530230361 #yiv8530230361ygrp-mlmsg pre, #yiv8530230361 code {font:115% monospace;}#yiv8530230361 #yiv8530230361ygrp-mlmsg * {line-height:1.22em;}#yiv8530230361 #yiv8530230361ygrp-mlmsg #yiv8530230361logo {padding-bottom:10px;}#yiv8530230361 #yiv8530230361ygrp-msg p a {font-family:Verdana;}#yiv8530230361 #yiv8530230361ygrp-msg p#yiv8530230361attach-count span {color:#1E66AE;font-weight:700;}#yiv8530230361 #yiv8530230361ygrp-reco #yiv8530230361reco-head {color:#ff7900;font-weight:700;}#yiv8530230361 #yiv8530230361ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8530230361 #yiv8530230361ygrp-sponsor #yiv8530230361ov li a {font-size:130%;text-decoration:none;}#yiv8530230361 #yiv8530230361ygrp-sponsor #yiv8530230361ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8530230361 #yiv8530230361ygrp-sponsor #yiv8530230361ov ul {margin:0;padding:0 0 0 8px;}#yiv8530230361 #yiv8530230361ygrp-text {font-family:Georgia;}#yiv8530230361 #yiv8530230361ygrp-text p {margin:0 0 1em 0;}#yiv8530230361 #yiv8530230361ygrp-text tt {font-size:120%;}#yiv8530230361 #yiv8530230361ygrp-vital ul li:last-child {border-right:none !important;}-->