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 #yiv5462548370 #yiv5462548370 --
#yiv5462548370ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv5462548370 #yiv5462548370ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv5462548370 #yiv5462548370ygrp-mkp #yiv5462548370hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5462548370 #yiv5462548370ygrp-mkp #yiv5462548370ads
{margin-bottom:10px;}#yiv5462548370 #yiv5462548370ygrp-mkp .yiv5462548370ad
{padding:0 0;}#yiv5462548370 #yiv5462548370ygrp-mkp .yiv5462548370ad p
{margin:0;}#yiv5462548370 #yiv5462548370ygrp-mkp .yiv5462548370ad a
{color:#0000ff;text-decoration:none;}#yiv5462548370 #yiv5462548370ygrp-sponsor
#yiv5462548370ygrp-lc {font-family:Arial;}#yiv5462548370
#yiv5462548370ygrp-sponsor #yiv5462548370ygrp-lc #yiv5462548370hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5462548370
#yiv5462548370ygrp-sponsor #yiv5462548370ygrp-lc .yiv5462548370ad
{margin-bottom:10px;padding:0 0;}#yiv5462548370 #yiv5462548370actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5462548370
#yiv5462548370activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5462548370
#yiv5462548370activity span {font-weight:700;}#yiv5462548370
#yiv5462548370activity span:first-child
{text-transform:uppercase;}#yiv5462548370 #yiv5462548370activity span a
{color:#5085b6;text-decoration:none;}#yiv5462548370 #yiv5462548370activity span
span {color:#ff7900;}#yiv5462548370 #yiv5462548370activity span
.yiv5462548370underline {text-decoration:underline;}#yiv5462548370
.yiv5462548370attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5462548370 .yiv5462548370attach div a
{text-decoration:none;}#yiv5462548370 .yiv5462548370attach img
{border:none;padding-right:5px;}#yiv5462548370 .yiv5462548370attach label
{display:block;margin-bottom:5px;}#yiv5462548370 .yiv5462548370attach label a
{text-decoration:none;}#yiv5462548370 blockquote {margin:0 0 0
4px;}#yiv5462548370 .yiv5462548370bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5462548370
.yiv5462548370bold a {text-decoration:none;}#yiv5462548370 dd.yiv5462548370last
p a {font-family:Verdana;font-weight:700;}#yiv5462548370 dd.yiv5462548370last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5462548370
dd.yiv5462548370last p span.yiv5462548370yshortcuts
{margin-right:0;}#yiv5462548370 div.yiv5462548370attach-table div div a
{text-decoration:none;}#yiv5462548370 div.yiv5462548370attach-table
{width:400px;}#yiv5462548370 div.yiv5462548370file-title a, #yiv5462548370
div.yiv5462548370file-title a:active, #yiv5462548370
div.yiv5462548370file-title a:hover, #yiv5462548370 div.yiv5462548370file-title
a:visited {text-decoration:none;}#yiv5462548370 div.yiv5462548370photo-title a,
#yiv5462548370 div.yiv5462548370photo-title a:active, #yiv5462548370
div.yiv5462548370photo-title a:hover, #yiv5462548370
div.yiv5462548370photo-title a:visited {text-decoration:none;}#yiv5462548370
div#yiv5462548370ygrp-mlmsg #yiv5462548370ygrp-msg p a
span.yiv5462548370yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5462548370
.yiv5462548370green {color:#628c2a;}#yiv5462548370 .yiv5462548370MsoNormal
{margin:0 0 0 0;}#yiv5462548370 o {font-size:0;}#yiv5462548370
#yiv5462548370photos div {float:left;width:72px;}#yiv5462548370
#yiv5462548370photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5462548370
#yiv5462548370photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5462548370
#yiv5462548370reco-category {font-size:77%;}#yiv5462548370
#yiv5462548370reco-desc {font-size:77%;}#yiv5462548370 .yiv5462548370replbq
{margin:4px;}#yiv5462548370 #yiv5462548370ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5462548370 #yiv5462548370ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5462548370
#yiv5462548370ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5462548370
#yiv5462548370ygrp-mlmsg select, #yiv5462548370 input, #yiv5462548370 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5462548370
#yiv5462548370ygrp-mlmsg pre, #yiv5462548370 code {font:115%
monospace;}#yiv5462548370 #yiv5462548370ygrp-mlmsg *
{line-height:1.22em;}#yiv5462548370 #yiv5462548370ygrp-mlmsg #yiv5462548370logo
{padding-bottom:10px;}#yiv5462548370 #yiv5462548370ygrp-msg p a
{font-family:Verdana;}#yiv5462548370 #yiv5462548370ygrp-msg
p#yiv5462548370attach-count span {color:#1E66AE;font-weight:700;}#yiv5462548370
#yiv5462548370ygrp-reco #yiv5462548370reco-head
{color:#ff7900;font-weight:700;}#yiv5462548370 #yiv5462548370ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5462548370 #yiv5462548370ygrp-sponsor
#yiv5462548370ov li a {font-size:130%;text-decoration:none;}#yiv5462548370
#yiv5462548370ygrp-sponsor #yiv5462548370ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5462548370
#yiv5462548370ygrp-sponsor #yiv5462548370ov ul {margin:0;padding:0 0 0
8px;}#yiv5462548370 #yiv5462548370ygrp-text
{font-family:Georgia;}#yiv5462548370 #yiv5462548370ygrp-text p {margin:0 0 1em
0;}#yiv5462548370 #yiv5462548370ygrp-text tt {font-size:120%;}#yiv5462548370
#yiv5462548370ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5462548370
merubah data (kata).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
