klo yang di maksud setiap hurup I di ganti menjadi Instruktur, maka bisa dengan
menambahkan Substitute di awal formula yang saya tunjukkan ke anda
=SUBSTITUTE ( _formula yang saya buat pertama_ ; _karakter yang akan di ganti_
; _karakter pengganti_ )
bila regional seting kompi setempat english maka ganti karakter titik koma ";"
menjadi koma ",".
br,
odong nando
Pada Jumat, 4 Desember 2015 12:14, "'prazt' [email protected]
[belajar-excel]" <[email protected]> menulis:
Makasih responnya, tapi jika huruf-huruf A s/d I saya ganti dengan
kata-kata, maka kata sambung da itu jadi terletak di tengah kataSebagai contoh
pada huruf I (dilampiran tadi) saya ganti instruktur maka hasilnya menjadi A,
B, C, D, E, F, G, H, instruktudan r . Seharusnya A, B, C, D, E, F, G, H, dan
instruktur.Dan jika huruf I saya ganti menjadi instruktur model maka hasilnya
A, B, C, D, E, F, G, H, instruktur modedan l . seharusnya A, B, C, D, E, F, G,
H, dan instruktur model From: [email protected]
[mailto:[email protected]]
Sent: 4 Desember 2015 11.32
To: [email protected]
Subject: Bls: [belajar-excel] mengganti tanda ", "(koma spasi) dangan ", dan
"(koma spasi dan spasi) yoo prazt, coba tator formula
=IFERROR(LEFT(Q6;LEN(Q6)-3)&"dan "&SUBSTITUTE(RIGHT(Q6;3);",";"")&".";"")
bila regional seting setempat english maka ganti karakter titik koma ";"
manjadi koma ",". pada cell R6, copas pada cells lain yang membutuhkan, klo ga
mau pake kolom bantu (Q6) tinggal masukin ja formula yang anda buat pada
formula diatas, br,
odong nando Pada Jumat, 4 Desember 2015 9:11, "'prazt' [email protected]
[belajar-excel]" <[email protected]> menulis: Selamat siang dan
semoga sehat selalu.Dear para mastah, mohon bantuan dan penjelasan bagaimana
rumus/formulanya cara mengganti tanda “, “ (koma spasi tanpa tanda petik)
dengan kata hubung “, dan “ (koma spasi dan spasi ) di kata/huruf terakhir
seperti ilustrasi pada lampiran berikut. Terima kasih sebelumnya.
| | Email tidak mengandung virus pemeriksaan mengunakan piranti Avast
antivirus.
www.avast.com |
| | Email tidak mengandung virus pemeriksaan mengunakan piranti Avast
antivirus.
www.avast.com |
#yiv6163725381 #yiv6163725381 -- #yiv6163725381ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6163725381
#yiv6163725381ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6163725381
#yiv6163725381ygrp-mkp #yiv6163725381hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6163725381 #yiv6163725381ygrp-mkp #yiv6163725381ads
{margin-bottom:10px;}#yiv6163725381 #yiv6163725381ygrp-mkp .yiv6163725381ad
{padding:0 0;}#yiv6163725381 #yiv6163725381ygrp-mkp .yiv6163725381ad p
{margin:0;}#yiv6163725381 #yiv6163725381ygrp-mkp .yiv6163725381ad a
{color:#0000ff;text-decoration:none;}#yiv6163725381 #yiv6163725381ygrp-sponsor
#yiv6163725381ygrp-lc {font-family:Arial;}#yiv6163725381
#yiv6163725381ygrp-sponsor #yiv6163725381ygrp-lc #yiv6163725381hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6163725381
#yiv6163725381ygrp-sponsor #yiv6163725381ygrp-lc .yiv6163725381ad
{margin-bottom:10px;padding:0 0;}#yiv6163725381 #yiv6163725381actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6163725381
#yiv6163725381activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6163725381
#yiv6163725381activity span {font-weight:700;}#yiv6163725381
#yiv6163725381activity span:first-child
{text-transform:uppercase;}#yiv6163725381 #yiv6163725381activity span a
{color:#5085b6;text-decoration:none;}#yiv6163725381 #yiv6163725381activity span
span {color:#ff7900;}#yiv6163725381 #yiv6163725381activity span
.yiv6163725381underline {text-decoration:underline;}#yiv6163725381
.yiv6163725381attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6163725381 .yiv6163725381attach div a
{text-decoration:none;}#yiv6163725381 .yiv6163725381attach img
{border:none;padding-right:5px;}#yiv6163725381 .yiv6163725381attach label
{display:block;margin-bottom:5px;}#yiv6163725381 .yiv6163725381attach label a
{text-decoration:none;}#yiv6163725381 blockquote {margin:0 0 0
4px;}#yiv6163725381 .yiv6163725381bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6163725381
.yiv6163725381bold a {text-decoration:none;}#yiv6163725381 dd.yiv6163725381last
p a {font-family:Verdana;font-weight:700;}#yiv6163725381 dd.yiv6163725381last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6163725381
dd.yiv6163725381last p span.yiv6163725381yshortcuts
{margin-right:0;}#yiv6163725381 div.yiv6163725381attach-table div div a
{text-decoration:none;}#yiv6163725381 div.yiv6163725381attach-table
{width:400px;}#yiv6163725381 div.yiv6163725381file-title a, #yiv6163725381
div.yiv6163725381file-title a:active, #yiv6163725381
div.yiv6163725381file-title a:hover, #yiv6163725381 div.yiv6163725381file-title
a:visited {text-decoration:none;}#yiv6163725381 div.yiv6163725381photo-title a,
#yiv6163725381 div.yiv6163725381photo-title a:active, #yiv6163725381
div.yiv6163725381photo-title a:hover, #yiv6163725381
div.yiv6163725381photo-title a:visited {text-decoration:none;}#yiv6163725381
div#yiv6163725381ygrp-mlmsg #yiv6163725381ygrp-msg p a
span.yiv6163725381yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6163725381
.yiv6163725381green {color:#628c2a;}#yiv6163725381 .yiv6163725381MsoNormal
{margin:0 0 0 0;}#yiv6163725381 o {font-size:0;}#yiv6163725381
#yiv6163725381photos div {float:left;width:72px;}#yiv6163725381
#yiv6163725381photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6163725381
#yiv6163725381photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6163725381
#yiv6163725381reco-category {font-size:77%;}#yiv6163725381
#yiv6163725381reco-desc {font-size:77%;}#yiv6163725381 .yiv6163725381replbq
{margin:4px;}#yiv6163725381 #yiv6163725381ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6163725381 #yiv6163725381ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6163725381
#yiv6163725381ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6163725381
#yiv6163725381ygrp-mlmsg select, #yiv6163725381 input, #yiv6163725381 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6163725381
#yiv6163725381ygrp-mlmsg pre, #yiv6163725381 code {font:115%
monospace;}#yiv6163725381 #yiv6163725381ygrp-mlmsg *
{line-height:1.22em;}#yiv6163725381 #yiv6163725381ygrp-mlmsg #yiv6163725381logo
{padding-bottom:10px;}#yiv6163725381 #yiv6163725381ygrp-msg p a
{font-family:Verdana;}#yiv6163725381 #yiv6163725381ygrp-msg
p#yiv6163725381attach-count span {color:#1E66AE;font-weight:700;}#yiv6163725381
#yiv6163725381ygrp-reco #yiv6163725381reco-head
{color:#ff7900;font-weight:700;}#yiv6163725381 #yiv6163725381ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6163725381 #yiv6163725381ygrp-sponsor
#yiv6163725381ov li a {font-size:130%;text-decoration:none;}#yiv6163725381
#yiv6163725381ygrp-sponsor #yiv6163725381ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6163725381
#yiv6163725381ygrp-sponsor #yiv6163725381ov ul {margin:0;padding:0 0 0
8px;}#yiv6163725381 #yiv6163725381ygrp-text
{font-family:Georgia;}#yiv6163725381 #yiv6163725381ygrp-text p {margin:0 0 1em
0;}#yiv6163725381 #yiv6163725381ygrp-text tt {font-size:120%;}#yiv6163725381
#yiv6163725381ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6163725381
