[belajar-excel] Digest Number 3598

Milis Belajar Microsoft Excel Group

6 Messages

Digest #3598

1a

Bls: [belajar-excel] Mencari Percentage dari sisa tanggal Exp by "Tony Bexcel"

2a

ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [help du by

2b

Re: ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [hel by "SUYONO"

2c

Re: ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [hel by "Yophi Akhmad"

2d

Re: ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [hel by "SUYONO"

2e

Re: ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [hel by "Yophi Akhmad"

Messages

1a

Bls: [belajar-excel] Mencari Percentage dari sisa tanggal Exp

Mon Oct 12, 2015 2:35 am (PDT) . Posted by:

"Tony Bexcel"

Dear Pakar yang Budiman,


Canggih Pak..hehehehe..makasih ya Pak Nang dan semua temans BeExceller..
Senang sekali cepat dapat jawaban sehingga bisa segera dipelajari dan dipakai ilmu nya.


Salam,
Tony B




Pada Senin, 12 Oktober 2015 16:03, "Nang Agus nangagus@gmail.com [belajar-excel]" menulis:




coba gunakan formula:
=IF(($L9-M$4)<0;"Expired";($L9-M$4)/$B9)


kopi ke semua cell,

Jangan Lupa format Cell dibuat % yaaa..


2015-10-12 10:56 GMT+07:00 Tony Bexcel tonybexcel@yahoo.co.id mailto:tonybexcel@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com mailto:belajar-excel@yahoogroups.com>:

Dear Pakar yang budiman,


Terimakasih atas jawaban yang sebelum nya, dalam soal kali ini merembet hingga mencari sebenar nya berapa persen kah sisa usia suatu barang bila diukur dari Tanggal masa berlaku ( Expired )
Untuk memudahkan nya telah saya lampirkan contoh soal agar dapat juga dipelajari untuk para pemula seperti saya.
Terimaksih atas segala waktu dan ilmu nya yang telah banyak membantu banyak umat.


Salam,
Tony B

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2a

ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [help du

Mon Oct 12, 2015 3:02 am (PDT) . Posted by:

para master

sy minta tulung dung, udah coba rumus buat gabungin data teks dgn tanggal tapi kok gagal terus ya?
format cellnya selalu muncul angka padahal rumusnya udah sy cek dan sama sekali ga ada yg beda dgn contoh rumusnya (di sheet 2)
(file terlampir)

mohon bantuannya master,
tks bgt ya

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2b

Re: ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [hel

Mon Oct 12, 2015 3:45 am (PDT) . Posted by:

"SUYONO"

Coba pake formula:

=A1&" "&TEXT(B1,"DD/MM/YY")

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Monday, October 12, 2015 4:59 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [help dunk] [1 Attachment]



para master

sy minta tulung dung, udah coba rumus buat gabungin data teks dgn tanggal tapi kok gagal terus ya?
format cellnya selalu muncul angka padahal rumusnya udah sy cek dan sama sekali ga ada yg beda dgn contoh rumusnya (di sheet 2)
(file terlampir)

mohon bantuannya master,
tks bgt ya

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2c

Re: ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [hel

Mon Oct 12, 2015 4:31 am (PDT) . Posted by:

"Yophi Akhmad"

trims respon cepetnya Om Reza, tapi seperti dilampiran sy sheet2 itu muncul respon error dari excelnya, naah itu dia sy ga tau kenapa....

ini sy lampirin lagi plus pesan errornya
--------------------------------------------
Pada Sen, 12/10/15, SUYONO reza.suyono@lge.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: RE: [belajar-excel] ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [help dunk]
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Tanggal: Senin, 12 Oktober, 2015, 5:45 PM


 

















Coba pake
formula:

 

=A1&"
"&TEXT(B1,"DD/MM/YY")

 





From:
belajar-excel@yahoogroups.com
[mailto:belajar-excel@yahoogroups.com]

Sent: Monday, October 12, 2015 4:59 PM

To: belajar-excel@yahoogroups.com

Subject: [belajar-excel] ask: gabung data teks dgn
tanggal, kenapa gagal
terus ya??? [help dunk] [1 Attachment]





 

 







para master



sy minta tulung dung, udah coba rumus buat gabungin data
teks dgn tanggal tapi
kok gagal terus ya?

format cellnya selalu muncul angka padahal rumusnya udah sy
cek dan sama sekali
ga ada yg beda dgn contoh rumusnya (di sheet 2)

(file terlampir)



mohon bantuannya master,

tks bgt ya

 
























#yiv0678692567 #yiv0678692567 --
#yiv0678692567ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv0678692567 #yiv0678692567ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv0678692567 #yiv0678692567ygrp-mkp #yiv0678692567hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv0678692567 #yiv0678692567ygrp-mkp #yiv0678692567ads {
margin-bottom:10px;}

#yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad {
padding:0 0;}

#yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad p {
margin:0;}

#yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad a {
color:#0000ff;text-decoration:none;}
#yiv0678692567 #yiv0678692567ygrp-sponsor
#yiv0678692567ygrp-lc {
font-family:Arial;}

#yiv0678692567 #yiv0678692567ygrp-sponsor
#yiv0678692567ygrp-lc #yiv0678692567hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv0678692567 #yiv0678692567ygrp-sponsor
#yiv0678692567ygrp-lc .yiv0678692567ad {
margin-bottom:10px;padding:0 0;}

#yiv0678692567 #yiv0678692567actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv0678692567 #yiv0678692567activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv0678692567 #yiv0678692567activity span {
font-weight:700;}

#yiv0678692567 #yiv0678692567activity span:first-child {
text-transform:uppercase;}

#yiv0678692567 #yiv0678692567activity span a {
color:#5085b6;text-decoration:none;}

#yiv0678692567 #yiv0678692567activity span span {
color:#ff7900;}

#yiv0678692567 #yiv0678692567activity span
.yiv0678692567underline {
text-decoration:underline;}

#yiv0678692567 .yiv0678692567attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv0678692567 .yiv0678692567attach div a {
text-decoration:none;}

#yiv0678692567 .yiv0678692567attach img {
border:none;padding-right:5px;}

#yiv0678692567 .yiv0678692567attach label {
display:block;margin-bottom:5px;}

#yiv0678692567 .yiv0678692567attach label a {

text-decoration:none;}

#yiv0678692567 blockquote {
margin:0 0 0 4px;}

#yiv0678692567 .yiv0678692567bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv0678692567 .yiv0678692567bold a {
text-decoration:none;}

#yiv0678692567 dd.yiv0678692567last p a {
font-family:Verdana;font-weight:700;}

#yiv0678692567 dd.yiv0678692567last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv0678692567 dd.yiv0678692567last p
span.yiv0678692567yshortcuts {
margin-right:0;}

#yiv0678692567 div.yiv0678692567attach-table div div a {
text-decoration:none;}

#yiv0678692567 div.yiv0678692567attach-table {
width:400px;}

#yiv0678692567 div.yiv0678692567file-title a, #yiv0678692567
div.yiv0678692567file-title a:active, #yiv0678692567
div.yiv0678692567file-title a:hover, #yiv0678692567
div.yiv0678692567file-title a:visited {
text-decoration:none;}

#yiv0678692567 div.yiv0678692567photo-title a,
#yiv0678692567 div.yiv0678692567photo-title a:active,
#yiv0678692567 div.yiv0678692567photo-title a:hover,
#yiv0678692567 div.yiv0678692567photo-title a:visited {
text-decoration:none;}

#yiv0678692567 div#yiv0678692567ygrp-mlmsg
#yiv0678692567ygrp-msg p a span.yiv0678692567yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv0678692567 .yiv0678692567green {
color:#628c2a;}

#yiv0678692567 .yiv0678692567MsoNormal {
margin:0 0 0 0;}

#yiv0678692567 o {
font-size:0;}

#yiv0678692567 #yiv0678692567photos div {
float:left;width:72px;}

#yiv0678692567 #yiv0678692567photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv0678692567 #yiv0678692567photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv0678692567 #yiv0678692567reco-category {
font-size:77%;}

#yiv0678692567 #yiv0678692567reco-desc {
font-size:77%;}

#yiv0678692567 .yiv0678692567replbq {
margin:4px;}

#yiv0678692567 #yiv0678692567ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg select,
#yiv0678692567 input, #yiv0678692567 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg pre, #yiv0678692567
code {
font:115% monospace;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg * {
line-height:1.22em;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg #yiv0678692567logo {
padding-bottom:10px;}


#yiv0678692567 #yiv0678692567ygrp-msg p a {
font-family:Verdana;}

#yiv0678692567 #yiv0678692567ygrp-msg
p#yiv0678692567attach-count span {
color:#1E66AE;font-weight:700;}

#yiv0678692567 #yiv0678692567ygrp-reco
#yiv0678692567reco-head {
color:#ff7900;font-weight:700;}

#yiv0678692567 #yiv0678692567ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv0678692567 #yiv0678692567ygrp-sponsor #yiv0678692567ov
li a {
font-size:130%;text-decoration:none;}

#yiv0678692567 #yiv0678692567ygrp-sponsor #yiv0678692567ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv0678692567 #yiv0678692567ygrp-sponsor #yiv0678692567ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv0678692567 #yiv0678692567ygrp-text {
font-family:Georgia;}

#yiv0678692567 #yiv0678692567ygrp-text p {
margin:0 0 1em 0;}

#yiv0678692567 #yiv0678692567ygrp-text tt {
font-size:120%;}

#yiv0678692567 #yiv0678692567ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv0678692567

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2d

Re: ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [hel

Mon Oct 12, 2015 4:44 am (PDT) . Posted by:

"SUYONO"

Coba seperti ini pak, bisa diganti komo ke titik koma.
Semoga sesuai keinginan.



From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Monday, October 12, 2015 6:21 PM
To: belajar-excel@yahoogroups.com
Subject: RE: [belajar-excel] ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [help dunk] [1 Attachment]



trims respon cepetnya Om Reza, tapi seperti dilampiran sy sheet2 itu muncul respon error dari excelnya, naah itu dia sy ga tau kenapa....

ini sy lampirin lagi plus pesan errornya
--------------------------------------------
Pada Sen, 12/10/15, SUYONO reza.suyono@lge.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: RE: [belajar-excel] ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [help dunk]
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Tanggal: Senin, 12 Oktober, 2015, 5:45 PM




















Coba pake
formula:



=A1&"
"&TEXT(B1,"DD/MM/YY")







From:
belajar-excel@yahoogroups.com
[mailto:belajar-excel@yahoogroups.com]

Sent: Monday, October 12, 2015 4:59 PM

To: belajar-excel@yahoogroups.com

Subject: [belajar-excel] ask: gabung data teks dgn
tanggal, kenapa gagal
terus ya??? [help dunk] [1 Attachment]















para master



sy minta tulung dung, udah coba rumus buat gabungin data
teks dgn tanggal tapi
kok gagal terus ya?

format cellnya selalu muncul angka padahal rumusnya udah sy
cek dan sama sekali
ga ada yg beda dgn contoh rumusnya (di sheet 2)

(file terlampir)



mohon bantuannya master,

tks bgt ya


























#yiv0678692567 #yiv0678692567 --
#yiv0678692567ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv0678692567 #yiv0678692567ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv0678692567 #yiv0678692567ygrp-mkp #yiv0678692567hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv0678692567 #yiv0678692567ygrp-mkp #yiv0678692567ads {
margin-bottom:10px;}

#yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad {
padding:0 0;}

#yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad p {
margin:0;}

#yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad a {
color:#0000ff;text-decoration:none;}
#yiv0678692567 #yiv0678692567ygrp-sponsor
#yiv0678692567ygrp-lc {
font-family:Arial;}

#yiv0678692567 #yiv0678692567ygrp-sponsor
#yiv0678692567ygrp-lc #yiv0678692567hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv0678692567 #yiv0678692567ygrp-sponsor
#yiv0678692567ygrp-lc .yiv0678692567ad {
margin-bottom:10px;padding:0 0;}

#yiv0678692567 #yiv0678692567actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv0678692567 #yiv0678692567activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv0678692567 #yiv0678692567activity span {
font-weight:700;}

#yiv0678692567 #yiv0678692567activity span:first-child {
text-transform:uppercase;}

#yiv0678692567 #yiv0678692567activity span a {
color:#5085b6;text-decoration:none;}

#yiv0678692567 #yiv0678692567activity span span {
color:#ff7900;}

#yiv0678692567 #yiv0678692567activity span
.yiv0678692567underline {
text-decoration:underline;}

#yiv0678692567 .yiv0678692567attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv0678692567 .yiv0678692567attach div a {
text-decoration:none;}

#yiv0678692567 .yiv0678692567attach img {
border:none;padding-right:5px;}

#yiv0678692567 .yiv0678692567attach label {
display:block;margin-bottom:5px;}

#yiv0678692567 .yiv0678692567attach label a {

text-decoration:none;}

#yiv0678692567 blockquote {
margin:0 0 0 4px;}

#yiv0678692567 .yiv0678692567bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv0678692567 .yiv0678692567bold a {
text-decoration:none;}

#yiv0678692567 dd.yiv0678692567last p a {
font-family:Verdana;font-weight:700;}

#yiv0678692567 dd.yiv0678692567last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv0678692567 dd.yiv0678692567last p
span.yiv0678692567yshortcuts {
margin-right:0;}

#yiv0678692567 div.yiv0678692567attach-table div div a {
text-decoration:none;}

#yiv0678692567 div.yiv0678692567attach-table {
width:400px;}

#yiv0678692567 div.yiv0678692567file-title a, #yiv0678692567
div.yiv0678692567file-title a:active, #yiv0678692567
div.yiv0678692567file-title a:hover, #yiv0678692567
div.yiv0678692567file-title a:visited {
text-decoration:none;}

#yiv0678692567 div.yiv0678692567photo-title a,
#yiv0678692567 div.yiv0678692567photo-title a:active,
#yiv0678692567 div.yiv0678692567photo-title a:hover,
#yiv0678692567 div.yiv0678692567photo-title a:visited {
text-decoration:none;}

#yiv0678692567 div#yiv0678692567ygrp-mlmsg
#yiv0678692567ygrp-msg p a span.yiv0678692567yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv0678692567 .yiv0678692567green {
color:#628c2a;}

#yiv0678692567 .yiv0678692567MsoNormal {
margin:0 0 0 0;}

#yiv0678692567 o {
font-size:0;}

#yiv0678692567 #yiv0678692567photos div {
float:left;width:72px;}

#yiv0678692567 #yiv0678692567photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv0678692567 #yiv0678692567photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv0678692567 #yiv0678692567reco-category {
font-size:77%;}

#yiv0678692567 #yiv0678692567reco-desc {
font-size:77%;}

#yiv0678692567 .yiv0678692567replbq {
margin:4px;}

#yiv0678692567 #yiv0678692567ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg select,
#yiv0678692567 input, #yiv0678692567 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg pre, #yiv0678692567
code {
font:115% monospace;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg * {
line-height:1.22em;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg #yiv0678692567logo {
padding-bottom:10px;}


#yiv0678692567 #yiv0678692567ygrp-msg p a {
font-family:Verdana;}

#yiv0678692567 #yiv0678692567ygrp-msg
p#yiv0678692567attach-count span {
color:#1E66AE;font-weight:700;}

#yiv0678692567 #yiv0678692567ygrp-reco
#yiv0678692567reco-head {
color:#ff7900;font-weight:700;}

#yiv0678692567 #yiv0678692567ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv0678692567 #yiv0678692567ygrp-sponsor #yiv0678692567ov
li a {
font-size:130%;text-decoration:none;}

#yiv0678692567 #yiv0678692567ygrp-sponsor #yiv0678692567ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv0678692567 #yiv0678692567ygrp-sponsor #yiv0678692567ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv0678692567 #yiv0678692567ygrp-text {
font-family:Georgia;}

#yiv0678692567 #yiv0678692567ygrp-text p {
margin:0 0 1em 0;}

#yiv0678692567 #yiv0678692567ygrp-text tt {
font-size:120%;}

#yiv0678692567 #yiv0678692567ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv0678692567

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2e

Re: ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [hel

Tue Oct 13, 2015 12:32 am (PDT) . Posted by:

"Yophi Akhmad"

terima kasih mas SUYONO, sesuai harapan saya, TOP BGT daaaah.
--------------------------------------------
Pada Sen, 12/10/15, SUYONO reza.suyono@lge.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: RE: [belajar-excel] ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [help dunk] [1 Attachment]
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Tanggal: Senin, 12 Oktober, 2015, 6:44 PM


 

















Coba seperti ini
pak, bisa diganti komo ke titik koma.

Semoga sesuai
keinginan.

 

 

 





From:
belajar-excel@yahoogroups.com
[mailto:belajar-excel@yahoogroups.com]

Sent: Monday, October 12, 2015 6:21 PM

To: belajar-excel@yahoogroups.com

Subject: RE: [belajar-excel] ask: gabung data teks
dgn tanggal, kenapa
gagal terus ya??? [help dunk] [1 Attachment]





 

 







trims respon cepetnya Om Reza, tapi seperti dilampiran sy
sheet2 itu muncul
respon error dari excelnya, naah itu dia sy ga tau
kenapa....



ini sy lampirin lagi plus pesan errornya

--------------------------------------------

Pada Sen, 12/10/15, SUYONO reza.suyono@lge.com
[belajar-excel]
<belajar-excel@yahoogroups.com> menulis:



Judul: RE: [belajar-excel] ask: gabung data teks dgn
tanggal, kenapa gagal
terus ya??? [help dunk]

Kepada: "belajar-excel@yahoogroups.com"
<belajar-excel@yahoogroups.com>

Tanggal: Senin, 12 Oktober, 2015, 5:45 PM





 



































Coba pake

formula:



 



=A1&"

"&TEXT(B1,"DD/MM/YY")



 











From:

belajar-excel@yahoogroups.com

[mailto:belajar-excel@yahoogroups.com]



Sent: Monday, October 12, 2015 4:59 PM



To: belajar-excel@yahoogroups.com



Subject: [belajar-excel] ask: gabung data teks dgn

tanggal, kenapa gagal

terus ya??? [help dunk] [1 Attachment]











 



 















para master







sy minta tulung dung, udah coba rumus buat gabungin data

teks dgn tanggal tapi

kok gagal terus ya?



format cellnya selalu muncul angka padahal rumusnya udah
sy

cek dan sama sekali

ga ada yg beda dgn contoh rumusnya (di sheet 2)



(file terlampir)







mohon bantuannya master,



tks bgt ya



 

















































#yiv0678692567 #yiv0678692567 --

#yiv0678692567ygrp-mkp {

border:1px solid #d8d8d8;font-family:Arial;margin:10px

0;padding:0 10px;}



#yiv0678692567 #yiv0678692567ygrp-mkp hr {

border:1px solid #d8d8d8;}



#yiv0678692567 #yiv0678692567ygrp-mkp #yiv0678692567hd {

color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px

0;}



#yiv0678692567 #yiv0678692567ygrp-mkp #yiv0678692567ads {

margin-bottom:10px;}



#yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad {

padding:0 0;}



#yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad p
{

margin:0;}




#yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad a
{

color:#0000ff;text-decoration:none;}

#yiv0678692567 #yiv0678692567ygrp-sponsor

#yiv0678692567ygrp-lc {

font-family:Arial;}



#yiv0678692567 #yiv0678692567ygrp-sponsor

#yiv0678692567ygrp-lc #yiv0678692567hd {

margin:10px

0px;font-weight:700;font-size:78%;line-height:122%;}



#yiv0678692567 #yiv0678692567ygrp-sponsor

#yiv0678692567ygrp-lc .yiv0678692567ad {

margin-bottom:10px;padding:0 0;}



#yiv0678692567 #yiv0678692567actions {

font-family:Verdana;font-size:11px;padding:10px 0;}



#yiv0678692567 #yiv0678692567activity {

background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}



#yiv0678692567 #yiv0678692567activity span {

font-weight:700;}



#yiv0678692567 #yiv0678692567activity span:first-child {

text-transform:uppercase;}



#yiv0678692567 #yiv0678692567activity span a {

color:#5085b6;text-decoration:none;}



#yiv0678692567 #yiv0678692567activity span span {

color:#ff7900;}



#yiv0678692567 #yiv0678692567activity span

.yiv0678692567underline {

text-decoration:underline;}



#yiv0678692567 .yiv0678692567attach {

clear:both;display:table;font-family:Arial;font-size:12px;padding:10px

0;width:400px;}



#yiv0678692567 .yiv0678692567attach div a {

text-decoration:none;}



#yiv0678692567 .yiv0678692567attach img {

border:none;padding-right:5px;}



#yiv0678692567 .yiv0678692567attach label {

display:block;margin-bottom:5px;}



#yiv0678692567 .yiv0678692567attach label a {



text-decoration:none;}



#yiv0678692567 blockquote {

margin:0 0 0 4px;}



#yiv0678692567 .yiv0678692567bold {

font-family:Arial;font-size:13px;font-weight:700;}



#yiv0678692567 .yiv0678692567bold a {

text-decoration:none;}



#yiv0678692567 dd.yiv0678692567last p a {

font-family:Verdana;font-weight:700;}



#yiv0678692567 dd.yiv0678692567last p span {

margin-right:10px;font-family:Verdana;font-weight:700;}



#yiv0678692567 dd.yiv0678692567last p

span.yiv0678692567yshortcuts {

margin-right:0;}



#yiv0678692567 div.yiv0678692567attach-table div div a {

text-decoration:none;}



#yiv0678692567 div.yiv0678692567attach-table {

width:400px;}



#yiv0678692567 div.yiv0678692567file-title a,
#yiv0678692567


div.yiv0678692567file-title a:active, #yiv0678692567

div.yiv0678692567file-title a:hover, #yiv0678692567

div.yiv0678692567file-title a:visited {

text-decoration:none;}



#yiv0678692567 div.yiv0678692567photo-title a,

#yiv0678692567 div.yiv0678692567photo-title a:active,

#yiv0678692567 div.yiv0678692567photo-title a:hover,

#yiv0678692567 div.yiv0678692567photo-title a:visited {

text-decoration:none;}



#yiv0678692567 div#yiv0678692567ygrp-mlmsg

#yiv0678692567ygrp-msg p a span.yiv0678692567yshortcuts {

font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv0678692567 .yiv0678692567green {

color:#628c2a;}



#yiv0678692567 .yiv0678692567MsoNormal {

margin:0 0 0 0;}



#yiv0678692567 o {

font-size:0;}



#yiv0678692567 #yiv0678692567photos div {


float:left;width:72px;}



#yiv0678692567 #yiv0678692567photos div div {

border:1px solid

#666666;height:62px;overflow:hidden;width:62px;}

#yiv0678692567 #yiv0678692567photos div label {

color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}



#yiv0678692567 #yiv0678692567reco-category {

font-size:77%;}



#yiv0678692567 #yiv0678692567reco-desc {

font-size:77%;}



#yiv0678692567 .yiv0678692567replbq {

margin:4px;}



#yiv0678692567 #yiv0678692567ygrp-actbar div a:first-child
{

margin-right:2px;padding-right:5px;}



#yiv0678692567 #yiv0678692567ygrp-mlmsg {

font-size:13px;font-family:Arial, helvetica, clean,

sans-serif;}



#yiv0678692567 #yiv0678692567ygrp-mlmsg table {

font-size:inherit;font:100%;}




#yiv0678692567 #yiv0678692567ygrp-mlmsg select,

#yiv0678692567 input, #yiv0678692567 textarea {

font:99% Arial, Helvetica, clean, sans-serif;}

#yiv0678692567 #yiv0678692567ygrp-mlmsg pre,
#yiv0678692567

code {

font:115% monospace;}



#yiv0678692567 #yiv0678692567ygrp-mlmsg * {

line-height:1.22em;}



#yiv0678692567 #yiv0678692567ygrp-mlmsg #yiv0678692567logo
{

padding-bottom:10px;}





#yiv0678692567 #yiv0678692567ygrp-msg p a {

font-family:Verdana;}



#yiv0678692567 #yiv0678692567ygrp-msg

p#yiv0678692567attach-count span {

color:#1E66AE;font-weight:700;}



#yiv0678692567 #yiv0678692567ygrp-reco

#yiv0678692567reco-head {

color:#ff7900;font-weight:700;}



#yiv0678692567 #yiv0678692567ygrp-reco {

margin-bottom:20px;padding:0px;}



#yiv0678692567 #yiv0678692567ygrp-sponsor
#yiv0678692567ov

li a {

font-size:130%;text-decoration:none;}



#yiv0678692567 #yiv0678692567ygrp-sponsor
#yiv0678692567ov

li {

font-size:77%;list-style-type:square;padding:6px 0;}



#yiv0678692567 #yiv0678692567ygrp-sponsor
#yiv0678692567ov

ul {

margin:0;padding:0 0 0 8px;}



#yiv0678692567 #yiv0678692567ygrp-text {

font-family:Georgia;}



#yiv0678692567 #yiv0678692567ygrp-text p {

margin:0 0 1em 0;}



#yiv0678692567 #yiv0678692567ygrp-text tt {

font-size:120%;}



#yiv0678692567 #yiv0678692567ygrp-vital ul li:last-child
{

border-right:none !important;

}

#yiv0678692567
























#yiv7519275181 #yiv7519275181 --
#yiv7519275181ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv7519275181 #yiv7519275181ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv7519275181 #yiv7519275181ygrp-mkp #yiv7519275181hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv7519275181 #yiv7519275181ygrp-mkp #yiv7519275181ads {
margin-bottom:10px;}

#yiv7519275181 #yiv7519275181ygrp-mkp .yiv7519275181ad {
padding:0 0;}

#yiv7519275181 #yiv7519275181ygrp-mkp .yiv7519275181ad p {
margin:0;}

#yiv7519275181 #yiv7519275181ygrp-mkp .yiv7519275181ad a {
color:#0000ff;text-decoration:none;}
#yiv7519275181 #yiv7519275181ygrp-sponsor
#yiv7519275181ygrp-lc {
font-family:Arial;}

#yiv7519275181 #yiv7519275181ygrp-sponsor
#yiv7519275181ygrp-lc #yiv7519275181hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv7519275181 #yiv7519275181ygrp-sponsor
#yiv7519275181ygrp-lc .yiv7519275181ad {
margin-bottom:10px;padding:0 0;}


#yiv7519275181 #yiv7519275181actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv7519275181 #yiv7519275181activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}


#yiv7519275181 #yiv7519275181activity span {
font-weight:700;}

#yiv7519275181 #yiv7519275181activity span:first-child {
text-transform:uppercase;}

#yiv7519275181 #yiv7519275181activity span a {
color:#5085b6;text-decoration:none;}

#yiv7519275181 #yiv7519275181activity span span {
color:#ff7900;}

#yiv7519275181 #yiv7519275181activity span
.yiv7519275181underline {
text-decoration:underline;}

#yiv7519275181 .yiv7519275181attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv7519275181 .yiv7519275181attach div a {
text-decoration:none;}

#yiv7519275181 .yiv7519275181attach img {
border:none;padding-right:5px;}

#yiv7519275181 .yiv7519275181attach label {
display:block;margin-bottom:5px;}

#yiv7519275181 .yiv7519275181attach label a {
text-decoration:none;}

#yiv7519275181 blockquote {
margin:0 0 0 4px;}


#yiv7519275181 .yiv7519275181bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv7519275181 .yiv7519275181bold a {
text-decoration:none;}

#yiv7519275181 dd.yiv7519275181last p a {
font-family:Verdana;font-weight:700;}

#yiv7519275181 dd.yiv7519275181last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv7519275181 dd.yiv7519275181last p
span.yiv7519275181yshortcuts {
margin-right:0;}

#yiv7519275181 div.yiv7519275181attach-table div div a {
text-decoration:none;}

#yiv7519275181 div.yiv7519275181attach-table {
width:400px;}

#yiv7519275181 div.yiv7519275181file-title a, #yiv7519275181
div.yiv7519275181file-title a:active, #yiv7519275181
div.yiv7519275181file-title a:hover, #yiv7519275181
div.yiv7519275181file-title a:visited {
text-decoration:none;}

#yiv7519275181 div.yiv7519275181photo-title a,
#yiv7519275181 div.yiv7519275181photo-title a:active,
#yiv7519275181 div.yiv7519275181photo-title a:hover,
#yiv7519275181 div.yiv7519275181photo-title a:visited {
text-decoration:none;}

#yiv7519275181 div#yiv7519275181ygrp-mlmsg
#yiv7519275181ygrp-msg p a span.yiv7519275181yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv7519275181 .yiv7519275181green {
color:#628c2a;}

#yiv7519275181 .yiv7519275181MsoNormal {
margin:0 0 0 0;}

#yiv7519275181 o {
font-size:0;}

#yiv7519275181 #yiv7519275181photos div {
float:left;width:72px;}

#yiv7519275181 #yiv7519275181photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv7519275181 #yiv7519275181photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv7519275181 #yiv7519275181reco-category {
font-size:77%;}

#yiv7519275181 #yiv7519275181reco-desc {
font-size:77%;}

#yiv7519275181 .yiv7519275181replbq {
margin:4px;}

#yiv7519275181 #yiv7519275181ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv7519275181 #yiv7519275181ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv7519275181 #yiv7519275181ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv7519275181 #yiv7519275181ygrp-mlmsg select,
#yiv7519275181 input, #yiv7519275181 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv7519275181 #yiv7519275181ygrp-mlmsg pre, #yiv7519275181
code {
font:115% monospace;}

#yiv7519275181 #yiv7519275181ygrp-mlmsg * {
line-height:1.22em;}

#yiv7519275181 #yiv7519275181ygrp-mlmsg #yiv7519275181logo {
padding-bottom:10px;}


#yiv7519275181 #yiv7519275181ygrp-msg p a {
font-family:Verdana;}

#yiv7519275181 #yiv7519275181ygrp-msg
p#yiv7519275181attach-count span {
color:#1E66AE;font-weight:700;}

#yiv7519275181 #yiv7519275181ygrp-reco
#yiv7519275181reco-head {
color:#ff7900;font-weight:700;}

#yiv7519275181 #yiv7519275181ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv7519275181 #yiv7519275181ygrp-sponsor #yiv7519275181ov
li a {
font-size:130%;text-decoration:none;}

#yiv7519275181 #yiv7519275181ygrp-sponsor #yiv7519275181ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv7519275181 #yiv7519275181ygrp-sponsor #yiv7519275181ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv7519275181 #yiv7519275181ygrp-text {
font-family:Georgia;}

#yiv7519275181 #yiv7519275181ygrp-text p {
margin:0 0 1em 0;}

#yiv7519275181 #yiv7519275181ygrp-text tt {
font-size:120%;}

#yiv7519275181 #yiv7519275181ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv7519275181

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 6

• Privacy • Unsubscribe • Terms of Use