[belajar-excel] Merubah kata dalam suatu data [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[belajar-excel] Merubah kata dalam suatu data [1 Attachment]

Milis Belajar Excel mailing list
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

merubah data.xlsm (13K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Merubah kata dalam suatu data [1 Attachment]

Milis Belajar Excel mailing list
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 [hidden email] [belajar-excel]" <[hidden email]>
 To: [hidden email]
 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 (15K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Merubah kata dalam suatu data

Milis Belajar Excel mailing list
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 [hidden email]
[belajar-excel]" <[hidden email]> 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 [hidden email] [belajar-excel]" <
> [hidden email]>
> *To:* [hidden email]
> *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
>

>
>
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Merubah kata dalam suatu data

Milis Belajar Excel mailing list
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 [hidden email] [belajar-excel]<[hidden email]> 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 [hidden email] [belajar-excel]" <[hidden email]> 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 [hidden email] [belajar-excel]" <[hidden email] >
 To: [hidden email]
 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  
Loading...