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

Mon, 12 Oct 2015 04:45:44 -0700 

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

Attachment: Copy of latihan euy (2).xlsx
Description: Copy of latihan euy (2).xlsx

Kirim email ke