; 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: *
: "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) *&
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
)&",";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:
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
5 matches
Mail list logo