Bls: [belajar-excel] Merangkum tanggal jadi satu

2014-03-22 Terurut Topik Tjahya Hartono
Terima kasih pak Wiranata Kemala dan Mr Kid atas solusinya Wassalam Tjahya H Pada Jumat, 21 Maret 2014 18:26, WIRAnata Kemala 鄧又銘 menulis:   bisa dicoba formula berikut: =CONCATENATE(C2," ",DAY(B2),","," ",C3," ",DAY(B3),","," ",C4," ",DAY(B4),","," ",C5," ",DAY(B5),","," ",C6," ",D

Re: [belajar-excel] Merangkum tanggal jadi satu [1 Attachment]

2014-03-21 Terurut Topik Mr. Kid
Hai Tjahya, File terlampir dengan sebuah kolom bantu. Coretan tentang menggabungkan teks multi baris ada disini . Wassalam, Kid. 2014-03-21 16:51 GMT+07:00 Tjahya Hartono : > > > > Dear Master Excel, > > >

Re: [belajar-excel] Merangkum tanggal jadi satu

2014-03-21 Terurut Topik WIRAnata Kemala 鄧又銘
bisa dicoba formula berikut: =CONCATENATE(C2," ",DAY(B2),","," ",C3," ",DAY(B3),","," ",C4," ",DAY(B4),","," ",C5," ",DAY(B5),","," ",C6," ",DAY(B6)," dan"," ",C7," ",DAY(B7)) semoga membantu :) 2014-03-21 16:51 GMT+07:00 Tjahya Hartono : > > > > Dear Master Excel, > > > Bagaimana ya rumusnya

[belajar-excel] Merangkum tanggal jadi satu [1 Attachment]

2014-03-21 Terurut Topik Tjahya Hartono
Dear Master Excel, Bagaimana ya rumusnya bila kasusnya terlampir. Terima kasih Wassalam Merangkum tanggal jadi satu.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet