2
5
9
3
2
3
0
4
6
9
0
3
0
0
0
25.932.3.046.903.000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
00.000.0.000.000.000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
00.000.0.000.000.000
2
5
9
3
2
3
0
4
6
9
0
3
0
0
0
25.932.3.046.903.000
2
5
9
3
2
3
0
4
6
9
0
3
0
0
0
25.932.3.046.903.000
2
5
9
3
2
3
0
4
6
9
0
3
0
0
0
25.932.3.046.903.000
9
3
2
3
0
4
.932.3.04 . .
. . .
. .
. . .
. .
Kosong maka akan disisipkan 1 spasi ?jika ya , rumusnta
=CONCATENATE(IF(A2=""," ",A2),IF(B2=""," ",B2),".",IF(C2= "", " ",C2),IF(D2=
"", " ",D2),IF(E2= "", " ",E2),".",IF(F2= "", " ",F2),".",IF(G2= "", "
",G2),IF(H2= "", " ",H2),IF(I2= "", " ",I2),".",IF(J2= "", " ",J2),IF(K2= "", "
",K2),IF(L2= "", " ",L2),".",IF(M2= "", " ",M2),IF(N2= "", " ",N2),IF(O2= "", "
",O2)) To: belajar-excel@yahoogroups.com
From: wewithi...@ymail.com
Date: Wed, 14 Mar 2012 08:13:19 -0700
Subject: [belajar-excel] Re: rumus apakah untuk menyembunyikan hasil rumus link?
hampir dikit lagi seperti yg diharapkan, mungkin kali ini filenya lebih
menjelaskan lagi.
-- Mods ---
Bapak sertakan saja hasil kerja manual (tanpa formulanya)
-----------