Re: Bls: [belajar-excel] Mengubah Format dan Template tabel

2011-05-17 Terurut Topik Mr. Kid
; 17,18,19 @ 2 > > Mohon pencerahannya, > > Terimakasih. > > Sent from my BlackBerry® > powered by Sinyal Kuat INDOSAT > -- > *From: * "Mr. Kid" > *Sender: * belajar-excel@yahoogroups.com > *Date: *Tue, 17 May 2011 19:33:05 +0700 > *To: *

Re: Bls: [belajar-excel] Mengubah Format dan Template tabel

2011-05-17 Terurut Topik yusajing_ehm
: "Mr. Kid" Sender: belajar-excel@yahoogroups.com Date: Tue, 17 May 2011 19:33:05 To: Reply-To: belajar-excel@yahoogroups.com Subject: Re: Bls: [belajar-excel] Mengubah Format dan Template tabel Coba array formula : =SUBSTITUTE(TRIM(JoinText(IF(LEN(B17:R17),DAY(B$13:R$13) *&

Re: Bls: [belajar-excel] Mengubah Format dan Template tabel

2011-05-17 Terurut Topik Mr. Kid
quot;,";H17)&REPT(DAY(I$13)&",";I17) > &REPT(DAY(J$13)&",";J17)&REPT(DAY(K$13)&",";K17) > &REPT(DAY(L$13)&",";L17)&REPT(DAY(M$13)&",";M17) > &REPT(DAY(N$13)&",";N17)&REPT(DAY(O$1

Re: Bls: [belajar-excel] Mengubah Format dan Template tabel

2011-05-17 Terurut Topik yusajing_ehm
)&",";N17)&REPT(DAY(O$13)&",";O17) &REPT(DAY(P$13)&",";P17)&REPT(DAY(Q$13)&",";Q17) &REPT(DAY(R$13)&",";R17) wassalam Ghozi Alkatiri --- Pada Sel, 17/5/11, Kurei recca menulis: Dari: Kurei recca Judul:

Re: [belajar-excel] Mengubah Format dan Template tabel

2011-05-17 Terurut Topik yusajing_ehm
ue, 17 May 2011 16:11:05 To: Reply-To: belajar-excel@yahoogroups.com Subject: Re: [belajar-excel] Mengubah Format dan Template tabel Hi Ridwan, Untuk menggabungkan text dari beberapa cell menjadi 1 cell, dapat menggunakan fungsi Concatenate, dan mungkin akan ribet jika cell-nya banyak. UD