Jika hurufnya kadang besar kadang kecil coba tambahkan fungsi Upper didepan kata2 ybs. Selamat mencoba. Salam,HK Sent from Yahoo Mail on Android On Sat, May 6, 2017 at 18:11, farud oke [email protected] [belajar-excel]<[email protected]> wrote:
Terima kasih mas hendrik.. Sudah sesuai dg yg di inginkan,cma untuk pncariannya hrus bnr2 spesifik.klo huruf prtama bsar mka d rumus hrus bsar jga.skali lgi trimakasih Pada tanggal 5 Mei 2017 4.34 PM, "hendrik karnadi [email protected] [belajar-excel]" <[email protected]> menulis: Hai Farud, Ada 2 tahapan yang saya buat...1. Menemukan kata "honorium" atau "Pembinaan" (Kolom Bantu)2. Jika tidak ditemukan salah satu dari kata2 tsb maka kata "Pembelian" tetap, namun jika ditemukan salah satu dari kata2 tersebut maka kata "Pembelian" diganti dengan kata "bayar" (Kolom Hasil). File terlampir. Semoga bermanfaat. Salam,HK From: "farud oke [email protected] [belajar-excel]" <[email protected] > To: [email protected] Sent: Friday, 5 May 2017, 12:35 Subject: [belajar-excel] Merubah kata dalam suatu data [1 Attachment] Mohon bimbingan dan bantuan para master semua Bagaimana caranya agar data yg ada bisa diubah secara otomatis dengan yg kata yg diharapkan.untuk lebih jelasnya sya lampirkan filenya. Atas bantuannya saya ucapkan terima kasih #yiv9749031159 #yiv9749031159 -- #yiv9749031159ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9749031159 #yiv9749031159ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9749031159 #yiv9749031159ygrp-mkp #yiv9749031159hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9749031159 #yiv9749031159ygrp-mkp #yiv9749031159ads {margin-bottom:10px;}#yiv9749031159 #yiv9749031159ygrp-mkp .yiv9749031159ad {padding:0 0;}#yiv9749031159 #yiv9749031159ygrp-mkp .yiv9749031159ad p {margin:0;}#yiv9749031159 #yiv9749031159ygrp-mkp .yiv9749031159ad a {color:#0000ff;text-decoration:none;}#yiv9749031159 #yiv9749031159ygrp-sponsor #yiv9749031159ygrp-lc {font-family:Arial;}#yiv9749031159 #yiv9749031159ygrp-sponsor #yiv9749031159ygrp-lc #yiv9749031159hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9749031159 #yiv9749031159ygrp-sponsor #yiv9749031159ygrp-lc .yiv9749031159ad {margin-bottom:10px;padding:0 0;}#yiv9749031159 #yiv9749031159actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9749031159 #yiv9749031159activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9749031159 #yiv9749031159activity span {font-weight:700;}#yiv9749031159 #yiv9749031159activity span:first-child {text-transform:uppercase;}#yiv9749031159 #yiv9749031159activity span a {color:#5085b6;text-decoration:none;}#yiv9749031159 #yiv9749031159activity span span {color:#ff7900;}#yiv9749031159 #yiv9749031159activity span .yiv9749031159underline {text-decoration:underline;}#yiv9749031159 .yiv9749031159attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9749031159 .yiv9749031159attach div a {text-decoration:none;}#yiv9749031159 .yiv9749031159attach img {border:none;padding-right:5px;}#yiv9749031159 .yiv9749031159attach label {display:block;margin-bottom:5px;}#yiv9749031159 .yiv9749031159attach label a {text-decoration:none;}#yiv9749031159 blockquote {margin:0 0 0 4px;}#yiv9749031159 .yiv9749031159bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9749031159 .yiv9749031159bold a {text-decoration:none;}#yiv9749031159 dd.yiv9749031159last p a {font-family:Verdana;font-weight:700;}#yiv9749031159 dd.yiv9749031159last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9749031159 dd.yiv9749031159last p span.yiv9749031159yshortcuts {margin-right:0;}#yiv9749031159 div.yiv9749031159attach-table div div a {text-decoration:none;}#yiv9749031159 div.yiv9749031159attach-table {width:400px;}#yiv9749031159 div.yiv9749031159file-title a, #yiv9749031159 div.yiv9749031159file-title a:active, #yiv9749031159 div.yiv9749031159file-title a:hover, #yiv9749031159 div.yiv9749031159file-title a:visited {text-decoration:none;}#yiv9749031159 div.yiv9749031159photo-title a, #yiv9749031159 div.yiv9749031159photo-title a:active, #yiv9749031159 div.yiv9749031159photo-title a:hover, #yiv9749031159 div.yiv9749031159photo-title a:visited {text-decoration:none;}#yiv9749031159 div#yiv9749031159ygrp-mlmsg #yiv9749031159ygrp-msg p a span.yiv9749031159yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9749031159 .yiv9749031159green {color:#628c2a;}#yiv9749031159 .yiv9749031159MsoNormal {margin:0 0 0 0;}#yiv9749031159 o {font-size:0;}#yiv9749031159 #yiv9749031159photos div {float:left;width:72px;}#yiv9749031159 #yiv9749031159photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9749031159 #yiv9749031159photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9749031159 #yiv9749031159reco-category {font-size:77%;}#yiv9749031159 #yiv9749031159reco-desc {font-size:77%;}#yiv9749031159 .yiv9749031159replbq {margin:4px;}#yiv9749031159 #yiv9749031159ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9749031159 #yiv9749031159ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9749031159 #yiv9749031159ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9749031159 #yiv9749031159ygrp-mlmsg select, #yiv9749031159 input, #yiv9749031159 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9749031159 #yiv9749031159ygrp-mlmsg pre, #yiv9749031159 code {font:115% monospace;}#yiv9749031159 #yiv9749031159ygrp-mlmsg * {line-height:1.22em;}#yiv9749031159 #yiv9749031159ygrp-mlmsg #yiv9749031159logo {padding-bottom:10px;}#yiv9749031159 #yiv9749031159ygrp-msg p a {font-family:Verdana;}#yiv9749031159 #yiv9749031159ygrp-msg p#yiv9749031159attach-count span {color:#1E66AE;font-weight:700;}#yiv9749031159 #yiv9749031159ygrp-reco #yiv9749031159reco-head {color:#ff7900;font-weight:700;}#yiv9749031159 #yiv9749031159ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9749031159 #yiv9749031159ygrp-sponsor #yiv9749031159ov li a {font-size:130%;text-decoration:none;}#yiv9749031159 #yiv9749031159ygrp-sponsor #yiv9749031159ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9749031159 #yiv9749031159ygrp-sponsor #yiv9749031159ov ul {margin:0;padding:0 0 0 8px;}#yiv9749031159 #yiv9749031159ygrp-text {font-family:Georgia;}#yiv9749031159 #yiv9749031159ygrp-text p {margin:0 0 1em 0;}#yiv9749031159 #yiv9749031159ygrp-text tt {font-size:120%;}#yiv9749031159 #yiv9749031159ygrp-vital ul li:last-child {border-right:none !important;}#yiv9749031159
