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

Tue, 13 Oct 2015 00:32:40 -0700 

terima kasih mas SUYONO, sesuai harapan saya, TOP BGT daaaah.
--------------------------------------------
Pada Sen, 12/10/15, SUYONO [email protected] [belajar-excel] 
<[email protected]> menulis:


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


  

















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

 Semoga sesuai
 keinginan.

   

   

   





 From:
 [email protected]
 [mailto:[email protected]]

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

 To: [email protected]

 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 [email protected]
 [belajar-excel]
 <[email protected]> menulis:



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

 Kepada: "[email protected]"
 <[email protected]>

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





  



































 Coba pake

 formula:



  



 =A1&"

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



  











 From:

 [email protected]

 [mailto:[email protected]]



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



 To: [email protected]



 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

Kirim email ke